N942AN
Service difficulty reports · 210
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N942AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N942AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA201912239022Filter · unknownAIRCRAFT WAS GROUNDED: RIGHT ENGINE FUEL FILTER BYPASS LIGHT ON THEN LIGHT EXTINGUISHED WITH POWER REDUCTION DURING DECENT. REPLACED FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA201912239006) AND FUEL FILTER (AALA201912239022) PER AMM 73-11-02 AND 73-34-01SDR AALA201912239006Pressure Switch · false indicationAIRCRAFT WAS GROUNDED. RIGHT ENGINE FUEL FILTER BYPASS LIGHT ON, THEN LIGHT EXTINGUISHED WITH POWER REDUCTION DURING DECENT. REPLACED THE FUEL FILTER DIFFERENTIAL PRESSURE SWITCH (AALA201912239006) AND FUEL FILTER (AALA201912239022) IAW AMM 73-11-02 AND SDR AALA201906189011Control Rod · out of adjustAIRCRAFT WAS GROUNDED: HANDLE AT 2L AFT ENTRY DOOR POPPED UP ON THE TAKEOFF ROLL, CAUSING MASTER CAUTION AND LOW SPEED 30 KNOT REJECT. HANDLE DOWN WAS PLACED DOWN AND IT POPPED AGAIN AFTER LIFT OFF. MAINTENANCE ACCOMPLISHED DOOR SYSTEM TEST PER AMM 52-13-00-70SDR AALA2019030189001Oil System · leakingA VOMIT ODOR IN THE CABIN. PERFORMED MCM 05-96-70 AND ON INSPECTION OF APU FOUND OIL LEAKING FROM APU TURBINE SCAVENGE LINE. APU HAS BEEN REPLACED IAW MCM 49-94-11. OPERATIONAL AND LEAK CHECK GOOD.SDR AALA201902069014Relay · malfunctionedTHE AIRCRAFT WAS GROUNDED. RIGHT HAND CENTER LOW PRESSURE LIGHT ILLUMINATED AFTER TAKEOFF. ONE CENTER TANK FUEL BOOST PUMP USABLE. REMOVED AND REPLACED RELAY R55 IAW FIM 28-22-00-810-802. CENTER TANK RIGHT FUEL PUMP OPS CHECK NORMAL.SDR AALA2018070529047Outflow Valve · malfunctionedAFTER TAKEOFF AT STT - CREW REALIZED CABIN COULD NOT BE PRESSURIZED. BLEADS OFF AND RE-ESTABLISHING PRESSURIZATION, WE NOTICED THE OUTFLOW VALVE WAS NOT CLOSED AND WOULD NOT CLOSE MANUALLY. THEY LEVELED OFF AT 5,000 FEET, DECLARED AN EMERGENCY AND LANDED WITHSDR AALA2018061208008Cable · unsecureAFTER TAKEOFF GEAR HANDLE WOULD ONLY MOVE TO OFF BUT NOT UP. RAN QRH PROCEDURE AND RETURNED TO DEPARTURE. AIRCRAFT WAS GROUNDED. SECURED LOWER END OF GROUND SPOILER BRAKE VALVE TELEFLEX CABLE IAW AMM 27-62-51. ACCOMPLISHED FUNCTIONAL TEST OF GROUND SPOILER SDR AALA20180516001Angle · crackedLEFT HORIZONTAL ANGLE ON THE BULKHEAD WEB CRACKED, OUTBOARD OF KEEL BEAM. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 111A1000.SDR AALA201805010012Stiffener · corrodedCORROSION ON LOWER HORIZONTAL STIFFENER IN THE APU INLET AROUND FASTENER HOLE BETWEEN BS 1088 TO 1136. REPLACED THE STIFFENER IAW SRM 51-10-02, 51-00-05, REPAIR 1, AND DRAWING 148A8650.SDR AALA201805010011Stiffener · corrodedCORROSION ON STIFFENER AT BS 1125, RIGHT SIDE IN APU BAY. REPLACED THE STIFFENER IAW 51-00-05-R1, AND DRAWING 148A8650.SDR AALA201804306003Floor Support · crackedCABIN FLOOR SUPPORT WAS FOUND CRACKED BETWEEN BS 312 - 328, RBL 31. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201805015007Floor Support · crackedFORWARD AND AFT FLOOR SUPPORT CRACKED AT BS 540, RBL 2. REPLACED FLOOR SUPPORT IAW SRM 51-10-02-0G, PARA 9.SDR AALA201804300008Floor Support · crackedFORWARD AFT FLOOR SUPPORT CRACKED AT BS 540, LBL 2. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02-0G PARAGRAPH 9.SDR AALA201803019017Slide · no testIAW MCM CARD 25-94-13 STEP 3A 4 AND 5 FAILED PULL TEST. MAINTENANCE REPLACED THE SLIDE AT THE RIGHT AFT GALLEY AND PERFORMED SATISFACTORY OPERATIONAL CHECK. THE AIRCRAFT WAS GROUNDEDSDR AALA201802269002Girt Bar · looseGIRT BAR AT FORWARD GALLEY SERVICE DOOR IS LOOSE ON RIGHT AFT SIDE. REINSTALLED THE GIRT BACK INTO THE SLIDE POCKET IAW AMM 25-66-01 . CHECKED FOR PROPER FOLDING. TESTED GIRT BAR INSTALLATION INTO FLOOR LOCKS . CHECKED GOOD .SDR AALA201712219027Sign · missingEMERGENCY EXIT SIGN MISSING AT AFT GALLEY DOOR LEFT SIDE. REPLACED EXIT SIGN IAW AMM 33-51-00.SDR AALA201712189031Girt Bar · brokenGIRT BAR AT THE L1 DOOR IS BROKEN ON ONE SIDE. REMOVED AND REPLACED THE GIRT BAR ANGLE IAW MCM 25-94-10.SDR AALA201711239006Strap · missingAIRCRAFT WAS NOT GROUNDED. 14F OVERWING EXIT LIFT STRAP IS MISSING. REPLACED DOOR AT 14F STRAP (LANYARD) COVER ASSEMBLY PER AMM 52-22-00. OPERATIONAL CHECK GOOD.SDR AALA201705039027Lens · detachedEMERGENCY LIGHT COVER CAME OFF AT LEFT AFT SERVICE DOOR. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-01, OPS CHECKED NORMAL.SDR AALA201704259036Light · crackedEMERGENCY EXIT LIGHT AT THE R4 DOOR IS CRACKED, AND DOES NOT STAY SECURED ON THE DOOR. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-00. CHECKED GOOD.SDR AALA20170210010Sign · detachedEMERGENCY EXIT SIGN AT R2 DOOR IS DETACHED. REPLACED EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA20170202024Light · disconnectedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY L2 DOOR IS DISCONNECTED. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170113001Static Port · contaminatedAIRCRAFT WAS GROUNDED. ABORTED TAKEOFF AT 75 KNOTS DUE TO INDICATED AIRSPEED ALERT. ACCOMPLISHED FIM 31-62-00-0810-876, NO FAULTS. FOUND WATER IN FIRST OFFICERS STATIC PORT. FLUSHED CARTS AND PITOT STATIC SYSTEM IAW AMM 34-11-00. LEAK AND OPERATIONAL CHECK GOOSDR AALA20161213017Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT L1 DOOR IS MISSING LENS COVER. INSTALLED LENS COVER. OPERATIONAL CHECK GOOD.SDR AALA20160809009Skin · wornFUSELAGE SKIN AT BS 1146 IS WORN ABOVE RIGHT HORIZONTAL STABILIZER LUG FITTING. REPAIRED THE SKIN IAW SRM 51-70-13-2R-3 AND EA 262500.SDR AALA20160803007Intercostal · crackedINTERCOSTAL AT LBL 48 BETWEEN BS 312 AND 328 IS CRACKED. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-40-02, AARD 51-00-05-1 AND DRAWING 141A5400.SDR AALA20160803006Intercostal · crackedINTERCOSTAL AT LBL 48 BETWEEN BS 328 AND 344 IS CRACKED. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-40-02, AARD 51-00-05-1 AND DRAWING 141A5400.SDR AALA20151202001Skin · corrodedCORROSION WAS FOUND ON THE FUSELAGE SKIN IN THE AREA OF THE AFT VENT PORT AT STATION 917, BETWEEN 21L & 22L. INSTALLED DOUBLER & TRIPLER REPAIR IAW EA 256390.SDR AALA20150528003Connector · unsecureEMERGENCY LIGHTS ROW 22 INOPERATIVE. SECURED CONNECTOR AT SEAT 22 IAW AMM 33-51-00. PERFORMED OPERATIONAL CHECK, NO DISCREPANCIES NOTED.SDR AALA20141218003Probe · defectiveAIR INTERRUPT, RETURNED, EMER DECLARED & LANDING UNEVENTFUL. ACFT NOT OVERWEIGHT. DURING CLIMB AUXILIARY PITOT SYS LIGHT ILLUMINATED & THE ASSOCIATED CB TRIPPED. R & R AUXILIARY PITOT PROBE IAW AMM 34-11-01. PERFORMED LEAK & OPERATIONAL CHECKED IAW AMM 34-SDR AALA20140806008Skin · dentedDENT IN FUSELAGE SKIN AT STATION 263 BETWEEN STRINGERS 15 & 16 RT. INSTALLED DOUBLER IAW EA B737-53-036025.SDR AALA20140805006Skin · crackedLEFT HORIZONTAL STABILIZER LOWER SKIN HAS CRACK APPROXIMATELY 71 INCHES OTBD OF INBD END & 16, 25 & 34 INCHES AFT OF FRONT SPAR. INSTALLED REPAIR DOUBLER & FILLERS IAW SRM 55-10-01-2R-11.SDR AALA20140804014Intercostal · crackedINTERCOSTAL CRACKED AT FASTENER HOLE BETWEEN STATIONS 312 TO 328 & LBL 52. INSTALLED NEW INTERCOSTAL IAW AARD 51-10-05.SDR AALA20140804013Skin · dentedDENT IN FUSELAGE SKIN FROM STATIONS 380 TO 400 BETWEEN STRINGERS 19 & 20 RT. REMOVED DAMAGE & INSTALLED DOUBLER IAW SRM 53-00-01-2R.SDR AALA20140803003Skin · damagedDENT WITH A RIVET PLUG WAS FOUND BETWEEN STATIONS 380 & 400 & STRINGERS 19 & 20 RT. REMOVED DAMAGE & INSTALLED DOUBLER IAW SRM 53-00-01-2R.SDR AALA20140522006Battery Pack · dischargedFORWARD EMERGENCY LIGHT BATTERY PACK M1674 FAILED CHECK. REPLACED EMERGENCY LIGHT BATTERY PACK M1674. OPERATIONS CHECKED NORMAL.SDR AALA20140522005Battery Pack · dischargedMID EMERGENCY LIGHT BATTERY PACK M1671 FAILED CHECK. REPLACED EMERGENCY LIGHT BATTERY PACK M1671. OPERATIONS CHECKED NORMAL.SDR AALA20140522004Battery Pack · dischargedAFT EMERGENCY LIGHT BATTERY PACK M1672 FAILED CHECK. REPLACED EMERGENCY LIGHT BATTERY PACK M1672. OPERATIONS CHECKED NORMAL.SDR AALA20140430005Floor Support · cracked727B LONGITUDINAL FLOORBEAM CRACKED RBL 24. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-034620.SDR AALA20140430004Floor Support · cracked727B LONGITUDINAL FLOORBEAM CRACKED LBL 45. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-034620.SDR AALA20140430003Floor Support · cracked727B LONGITUDINAL FLOORBEAM CRACKED LBL 24. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-034620.SDR AALA20140428006Floor Support · cracked727B LONGITUDINAL FLOORBEAM CRACKED RBL 24. ACCOMPLISHED NESTED ANGLE REPAIR IAW EA B737-53-034620.SDR AALA20121217039Deu · inoperativeMBJ - CREW REPORTED BOTH CAPTAINS AND FIRST OFFICERS DISPLAY UNIT BLANKING. FLIGHT RETURNED MBJ LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED DISPLAY ELECTRONIC UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20121123011Radar · inoperativeMIA - CREW REPORTED WEATHER RADAR FAILED. FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED WEATHER RADAR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120601013Stringer · corrodedSTRINGER 22 LEFT CORRODED AT STATION 312. REPLACED STRINGER PER EA 737-53-023999.SDR AALA20120601008Stringer · corrodedCORROSION ON STRINGER 22 LEFT AT STATION 323. REPLACED STRINGER PER EA 737-53-023999 AND AARD 51-00-05-1 DRAWING 141A8240-37.SDR AALA20120601007Stringer · corrodedCORROSION ON STRINGER 22 LEFT, STATION 330.6. REPLACED STRINGER PER EA 737-53-023999 AND AARD 51-00-05-1, DRAWING 141A8240-37.SDR AALA20120529016Trans Panel · corrodedLEFT FORWARD CARGO SIDEWALL TRANSITION PANEL CORRODED AT STATION 436. REMOVED AND REPLACED PANEL PER AARD 51-00-05-1.SDR AALA20120528018Web · corrodedCORROSION ON FORWARD CARGO DOOR CUTOUT FLOOR WEB STATIONS 440 TO 492. REPLACED WEB PER AARD 51-00-5.SDR AALA20120525016Intercostal · crackedINTERCOSTAL CRACKED AT FLOOR, LEFT BUTTLINE 0 FROM STATIONS 344 TO 360. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02 AND AARD 51-00-05-1.
Back to N942AN