N929AN
Service difficulty reports · 254
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 = 'N929AN' 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 = 'N929AN' 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 AALA20170919015Baffle · crackedCRACKED BAFFLE IN THE FORWARD CARGO UNDER THE LEFT TRANSITION PANEL BETWEEN SS 460 AND 480. REMOVED AND REPLACED BAFFLE IAW D 51-00-05 AND DRAWING 143A7510.SDR AALA20170919008Web · corrodedCORROSION FOUND ON THE RIGHT HALF MOON WEB BETWEEN BS 1016 AND 1026, RBL 28 TO RBL 38. REMOVED AND REPLACED THE WEB IAW D 51-00-05-1 AND DRAWING 147A5700.SDR AALA20170919007Floorbeam · corrodedCORROSION ON FORWARD CARGO AFT FLOORBEAM ANGLE AT BS 500I, LONGERONS 25L AND 25R. REMOVED AND REPLACED THE FLOORBEAM ANGLE SRM 51-10-02 AND D 51-00-05.SDR AALA20170919006Web · corrodedCORROSION ON FORWARD CARGO LOWER DOOR FRAME SILL PLATE WEB BETWEEN BS 440 AND 492, STRINGER 26R. REMOVED AND REPLACED THE WEB IAWSRM 51-40-02.SDR AALA20170917002Transition Panel · corrodedCORROSION ON FORWARD CARGO LEFT TRANSITION PANEL FROM BS 500 TO 500I. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA20170917003Transition Panel · corrodedCORROSION ON FORWARD CARGO RIGHT TRANSITION PANELS BETWEEN FUSELAGE STATIONS 420 AND 440 AND BETWEEN FUSELAGE STATIONS 500 AND 500I. REMOVED AND REPLACED TRANSITION PANELS IAW DWG 51-00-05-1, SRM 51-10-02, SRM 53-00-53-2R, AND DRAWING 143A8126.SDR AALA20170911006Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 45. REMOVED AND REPLACED THE FLOOR SUPPORT IAW D 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170911005Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 AND 344, LBL45. REMOVED AND REPLACED THE FLOOR SUPPORT IAW DWG 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170926004Transition Panel · corrodedCORROSION ON AFT CARGO RIGHT TRANSITION PANEL BETWEEN BS 847 AND 867, STRINGER 25R. INSTALLED A NEW TRANSITION PANEL IAW SRM 53-00-53.SDR AALA20170914002Angle · corrodedCORROSION ON THE L1 DOOR LOWER SILL CREASE ANGLE BETWEEN BS 300 AND 306. REMOVED AND REPLACED THE CREASE ANGLE IAW SRM 53-10-15, DWG 51-00-05-1, AND DRAWING 141A8110.SDR AALA20170527007Shutoff Valve · uncontrollableEMERGENCY DECLARED. FLIGHT DIVERTED DUE TO CABIN TEMPERATURE WAS EXTREMELY HOT. REMOVED AND REPLACED THE ZONE TEMPERATURE CONTROL TRIM AIR PRESSURE REGULATOR AND SHUTOFF VALVE ASSEMBLY IAW AMM 21-62-01. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170104019Sign · detachedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN AT R2 DOOR NEAR TRASH BIN IS DETACHED. SECURED EXIT SIGN IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20160819003Valve · out of adjustDURING CLIMB LANDING GEAR RETRACTED NORMALLY BUT EXTENDED UNCOMMANDED WHEN GEAR HANDLE WAS PLACED IN THE OFF POSITION. EMERGENCY DECLARED. LANDING UNEVENTFUL. THE AIRCRAFT WAS GROUNDED. MAINTENANCE ADJUSTED GEAR SELECTOR VALVE IAW 32-31-00. ACCOMPLISHED SUCCSDR AALA20160421009Window Frame · crackedAIRCRAFT WAS IN BASE MX. FLIGHT DECK R1 WINDOW FRAME IS CRACKED AT UPPER OTBD CORNER. REPAIRED WINDOW FRAME IAW EA 259557 & SB 737-53-136.SDR AALA20160420002Pressure Panel · crackedAIRCRAFT WAS IN BASE MX. VERTICAL PRESS WEB AT FS 663.75 IS CRACKED, BETWEEN RBL 31.83 & RBL 40. REPAIRED WEB IAW EA 259600.SDR AALA20160413004Intercostal · crackedAIRCRAFT WAS IN BASE MX. CABIN FLOOR INTERCOSTAL AT FWD ENTRY DOOR, BETWEEN FUSELAGE STATIONS 312 & 328 IS CRACKED. R & R INTERCOSTAL IAW AARD 51-10-05-1.SDR AALA20160413003Intercostal · crackedAIRCRAFT WAS IN BASE MX. CABIN FLOOR INTERCOSTAL AT FWD ENTRY DOOR, BETWEEN FUSELAGE STATIONS 328 & 344 IS CRACKED. R & R INTERCOSTAL IAW SRM 53-10-51 & DWG 141A5400.SDR AALA20160203004Transition Panel · corrodedAIRCRAFT WAS IN BASE MX. FWD CARGO COMPARTMENT LT TRANSITION PANEL IS CORRODED, AT APPROX FS 480. REPAIRED TRANSITION PANEL IAW SRM 53-00-53-2R.SDR AALA20150331002Light · inoperativeEMERGENCY AREA FLOODLIGHT ASSEMBLY ON OVERHEAD ABOVE SEAT 25D FOUND INOPERATIVE DURING OPERATIONAL TEST OF EMERGENCY LIGHTS IAW MCM CARD 2904. RELAMPED EMER LIGHT IAW AMM 33-51-03. SYS CHECKED NORMAL.SDR AALA20141107004Cover · missingR2 DOOR AREA INTERIOR EMER EXIT IDENTIFIER LIGHT COVER MISSING. REPLACED EMER EXIT IDENTIFIER LIGHT AT R2 DOOR AFT IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20140228002Floor Panel · damagedSMALL HOLE IN AFT CARGO FLOOR PANEL AT STATION 792 RT. REPLACED PANEL IAW AMM 25-52-10.SDR AALA20140227001Scuff Plate · gougedDENT WITH GOUGE IN AFT CARGO DOOR SCUFF PLATE. R & R SCUFF PLATE IAW AMM 53-11-02.SDR AALA20131031011Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B & RBL 45.50. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW ECO J1707AA/AB & EA B737-53-032183.SDR AALA20131031010Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B & LBL 24.75. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW ECO J1707AA/AB & EA B737-53-032183.SDR AALA20131031009Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B & LBL 45.50. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW ECO J1707AA/AB & EA B737-53-032183.SDR AALA20131025002Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B & RBL 24.75. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW ECO J1707AA/AB & EA B737-53-032183.SDR AALA20131025007Fastener · shearedFASTENER SHEARED IN SEAT TRACK AT STATION 727B & RBL 45.50. ACCOMPLISHED FASTENER REPAIR IAW ECO J1707AB CARD 003 & EA B737-53-032813.SDR AALA20130521020Pressure Switch · failedCREW REPORTED RT ENGINE FUEL FILTER BYPASS LIGHT ILLUMINATED. EMERGENCY DECLARED, FLIGHT RETURNED T/O DEPARTURE, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE FOR REPAIR. REPLACED S241 DIFFERENTIAL PRESSURE SWITCH. SYS GROUND CHECK NORMAL OPS. (CLOSEDSDR AALA20130518008Fseu · inoperativeINFLIGHT, CREW REPORTED FLAPS WOULD NOT DEPLOY FURTHER THAN 1 DEGREE. EMERGENCY DECLARED, FLIGHT DIVERTED, AND LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED FLAP SLAT ELECTRONICS UNIT. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130516016Sensor · inoperativeCREW REPORTED T/E FLAP ASYMMETRY MESSAGE. EMERGENCY DECLARED, FLIGHT DIVERTED AND LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED NR 7 SKEW SENSOR. SYS GROUND CHECK NORMAL OPERATION.SDR AALA20130510001Transmitter · inoperativeBOS - CREW REPORTED FLAP LEVER SELECTED TO 1 DEGREE AND NOTHING HAPPENED. FOLLOWED QRH AND EXTENDED SLATS WITH ALTERNATE FLAP SWITCH. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLAP LEVER POSITION TRANSMITTER AND FLAP SKEW SENSOR. SYSTEM GROUND CHECK NORMAL OSDR AALA20121107038Unknown · malfunctionedSFO - FLIGHT ATTENDANTS REPORTED A STRONG SMELL OF SMOKE IN THE AFT CABIN JUST BEFORE LANDING. FLIGHT ATTENDANTS TURNED OFF THE POWER PORTS AND SMELL OF SMOKE SLOWLY DISSIPATED. AIRCRAFT REMOVED FROM SERVICE. REPLACED R917. SYSTEM GROUND CHECK NORMAL OPERASDR AALA20120601010Lens · missingBULLNOSE EMERGENCY LIGHT LENS AT ROW 18ABC IS MISSING. REPLACED LENS FOR BULLNOSE EMERGENCY LIGHT AT ROW 18ABC. OPS CHECK NORMAL.SDR AALA20120504017Connector · not seatedBULLNOSE EMERGENCY EXIT LIGHTS THROUGHOUT CABIN INOPERATIVE. RESEATED CONNECTORS THROUGHOUT CABIN, OPS CHECK NORMAL.SDR AALA20120505012Battery Pack · dischargedEMERGENCY LIGHTS BATTERY PACK M1670 INOPERATIVE. REPLACED BATTERY PACK M1670 FOR CABIN EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20120505019Lens · damagedRIGHT FORWARD OVERWING EMERGENCY EXIT LIGHT LENS ASSEMBLY DAMAGED. REPLACED LENS FOR RIGHT FORWARD OVERWING EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120505018Light · inoperativeRIGHT FORWARD CABIN OVERWING EMERGENCY EXIT HANDLE LAMP INOPERATIVE. REPLACED LAMP IN RIGHT FORWARD CABIN OVERWING EMERGENCY EXIT HANDLE LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20120505017Light · inoperativeRIGHT FORWARD OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LAMP RIGHT FORWARD OVERWING EMERGENCY EXIT. OPS CHECK NORMAL.SDR AALA20120505016Light · inoperativeSEAT 7D FORWARD EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 7D FORWARD EMERGENCY EXIT LIGHT. OPS CHECK NORMAL.SDR AALA20120505015Connector · not seatedBULLNOSE EMERGENCY LIGHTS THRU-OUT CABIN INOPERATIVE. RESEATED CONNECTORS FOR EMERGENCY LIGHTS THRU-OUT CABIN. OPS CHECK NORMAL.SDR AALA20120505014Battery Pack · dischargedFOUND BATTERY PACK M1674 INOPERATIVE. REPLACED BATTERY PACK M1674. OPS CHECK NORMAL.SDR AALA20120505013Lens · missingEMERGENCY LIGHT AT 18A UPPER BULLNOSE MISSING LENS. REPLACED LENS FOR 18A UPPER BULLNOSE EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120127TUL04Track · corrodedCORROSION ON AFT CARGO SUPPORT TRACK BETWEEN STATIONS 787 TO 847. INSTALLED STRAP PER EA B737-53-021410.SDR AALA20120125TUL10Floorbeam · corrodedCORROSION ON UPPER SURFACE OF FLOORBEAM STATION 312 RIGHT BUTTLINE 13. ACCOMPLISHED NESTED ANGLE REPAIR PER AARD 53-00-00-7.SDR AALA20120120TUL32Floorbeam · corrodedCORROSION ON UPPER CAP OF TRANSVERSE FLOORBEAM STATION 294. INSTALLED UPPER CAP SPLICE REPAIR PER EA B737-53-021106.SDR AALA20120120TUL27Intercostal · corrodedCORROSION ON UPPER SURFACE OF INTERCOSTAL BETWEEN STATIONS 312 AND 328, APPROXIMATELY RIGHT BUTTLINE 26. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA20120120TUL04Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 312 AND 328 FLOORBEAMS, RIGHT BUTTLINE 31 CRACKED. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-10-05-1.SDR AALA20120119TUL11Floorbeam · corrodedSTATION 328 TEE CAP CORRODED AT RIGHT BUTTLINE 1. REMOVED CORRODED FLANGE AND INSTALLED REPAIR PER SRM 53-10-51-2R 7.SDR AALA20120117TUL06Floorbeam · corrodedENTIRE FLOORBEAM UPPER CAP AT STATION 986 CORRODED. INSTALLED T-CAP REPAIR PER SRM 53-70-51.SDR AALA20120117TUL05Channel · corrodedCORROSION ON LEFT Z-CHANNEL FASTENER HOLES. INSTALLED NEW SECTION OF Z-CHANNEL FROM STATIONS 767 TO 847 PER SRM 53-00-53-2R.
Back to N929AN