N931AN
Service difficulty reports · 206
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 = 'N931AN' 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 = 'N931AN' 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 AALA202301308481Light · inoperativeAIRCRAFT WAS GROUNDED: EXTERIOR EMERGENCY LIGHT INOPERATIVE AT LEFT FORWARD OVER-WING EXIT DOOR. REPLACED LEFT OVER-WING EMERGENCY LIGHT IAW AMM 33-51-04.SDR AALA202211258541Gust Lock · inoperativeAIRCRAFT WAS GROUNDED: R1 DOOR GUST LOCK BUTTON MISSING. REPLACED R1 DOOR LATCH RELEASE MECHANISM PER AMM 20-50-11.SDR AALA202211219920Button · missingAIRCRAFT WAS GROUNDED: LEFT AFT ENTRY DOOR CAN'T SHUT. GUST LOCK BUTTON MISSING. REPLACED GUST LOCK BUTTON AND OPERATIONAL CHECKED GOOD PER AMM 52-13-00.SDR AALA202211211280Switching Unit · faultyAIRCRAFT WAS GROUNDED: SPEED TRIM FAIL LIGHT ILLUMINATED DURING CLIMB OUT. BOTH AUTOPILOT CHANNELS INOPERATIVE. EMERGENCY DECLARED; FLIGHT DIVERTED TO DFW LANDING SAFELY. SPEED TRIM FAIL CORRECTED BY REPLACING LEFT HAND AOA VANE (AALA202211180728) PER AMM 34-SDR AALA202211210728Sensor · failedAIRCRAFT WAS GROUNDED: SPEED TRIM FAIL LIGHT ILLUMINATED DURING CLIMB OUT. BOTH AUTOPILOT CHANNELS INOPERATIVE. EMERGENCY DECLARED; FLIGHT DIVERTED TO DFW LANDING SAFELY. SPEED TRIM FAIL CORRECTED BY REPLACING LEFT HAND AOA VANE (AALA202211180728) PER AMM 34-SDR AALA202208299404Smoke Detector · inoperativeAIRCRAFT IN BASE MAINTENANCE: LAVATORY D AND E FAIL SMOKE DETECTORS CHECK. REMOVED AND REPLACED LAVATORY D (AALA202208299721) AND LAVATORY E (AALA202208299404) SMOKE DETECTORS PER B737NG AMM 26-14-01.SDR AALA202208299721Smoke Detector · inoperativeAIRCRAFT IN BASE MAINTENANCE: LAVATORY D AND E FAIL SMOKE DETECTORS CHECK. REMOVED AND REPLACED LAVATORY D (AALA202208299721) AND LAVATORY E (AALA202208299404) SMOKE DETECTORS PER B737NG AMM 26-14-01.SDR AALA202208168192Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FRAME CRACKED STA 480 AND STR 0. REMOVED DAMAGED FRAME SECTION AND INSTALLED REPAIR CHANNELS PER SRM 53-00-07-2R-1.SDR AALA202001309012Ballast · failedAIRCRAFT NOT GROUNDED: EMERG EXIT OVER 14F DOES NOT ILLUMINATE. MEL APPLIED.***SUPPLEMENTAL ACTION SECT 4 AND 5: REPLACED BALLAST ASSY AT 14F SIDEWALL LIGHT PER AMM 33-21-00.***(CLOSED)SDR AALA202001299010Ballast · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERWING LIGHT INOPERATIVE AT RIGHT HAND FORWARD POSITION. MAINTENANCE REPLACED OVERWING LIGHT BALLAST PER AMM 33-21-00-960-807.SDR AALA2019102219006Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT SEAT NEXT TO L1 DOOR INOPERABLE. MAINTENANCE REPLACED FLASHLIGHT PER MM 25-64-00.SDR AALA201909159019Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: FLIGHT RETURNED TO DFW ON ACCOUNT OF RIGHT ENGINE FUEL BYPASS INDICATION. AN EMERGENCY WAS DECLARED. MAINTENANCE ACCOMPLISHED BITE CHECK IAW FIM 73-05-00. REMOVED & REPLACED RT FUEL FILTER IAW JOB CARD 73-94-13.SDR AALA2018110879005Tire · explodedTIRE TREAD LOSS OR TIRE BURST. THE AIRCRAFT WAS GROUNDED. A CONDITIONAL INSPECTION WAS ACCOMPLISHED IAW AMM 05-51-54-210-801. THE NR 2 TIRE EXPLODED. REPLACED THE TIRE IAW AMM 32-45-11.SDR AALA20171031005Stiffener · crackedCRACK INDICATION ON VERTICAL STIFFENER AT AFT INBOARD CORNER OF RIGHT A/C BAY. REPAIRED IAW SRM 51-70-04-2R, REPAIR 10, DRAWINGS 144A6199, AND 144A6122.SDR AALA20171031004Doubler · crackedCRACK INDICATION ON EXHAUST CUTOUT DOUBLER. REMOVED AND REPLACED THE DOUBLER IAW 51-00-05-1R1, AND DRAWING 111A1000-0101, REVISION B.SDR AALA20171031003Angle · crackedCRACK INDICATION ON AN ANGLE OF THE BULKHEAD. REMOVED AND REPLACED THE ANGLE IAW 51-00-05-1, DRAWING 111A1000, AND SRM 57-10-10-2R.SDR AALA201711019021Angle · corrodedCORROSION ON G4 GALLEY RIGHT LOWER WALL SUPPORT ZEE ANGLE BETWEEN BS 991 AND 1014, RBL 32. REMOVED AND REPLACED THE ANGLE IAW 51-00-05-1, AND PRINT 147A5700.SDR AALA20171030005Angle · corrodedCORROSION ON G4 GALLEY LEFT LOWER WALL SUPPORT ZEE ANGLE BETWEEN BS 991 AND 1014, LBL 32. REMOVED AND REPLACED THE ANGLE IAW 51-00-05-1 AND 147A5700.SDR AALA201711019020Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY WEB PAN TOP STRAP BETWEEN FUSELAGE STATIONS 1018 AND 1021 AT LBL27. REMOVED AND REPLACED STRAP PER AARD 51-00-05-1 AND DRAWING 147A5714-3.SDR AALA201711019019Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY WEB PAN TOP STRAP BETWEEN FUSELAGE STATIONS 1018 AND 1029 AT LBL17. REMOVED AND REPLACED STRAP PER AARD 51-00-05-1 AND DRAWING 147A5714-3.SDR AALA201711019018Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY WEB PAN TOP STRAP BETWEEN FUSELAGE STATIONS 1016 AND 1021 AT RBL3. REMOVED AND REPLACED STRAP PER AARD 51-00-05-1 AND DRAWING 147A5714-3.SDR AALA20171030003Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY WEB PAN TOP STRAP BETWEEN FUSELAGE STATIONS 1016 AND 1021 AT LBL3. REMOVED AND REPLACED STRAP PER AARD 51-00-05-1 AND DRAWING 147A5714-3.SDR AALA201710319076Web · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY LOWER LEFT AFT WEB PANEL BETWEEN FUSELAGE STATIONS 1016 AND 1018, LBL6 TO LBL12. REMOVED AND REPLACED WEB PER 51-00-05-1 AND PRINT 147A5712-44.SDR AALA20171030002Web · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON G4 GALLEY LOWER RIGHT AFT WEB PANEL BETWEEN FUSELAGE STATIONS 1016 AND 1020, RBL30 TO RBL34. REMOVED AND REPLACED WEB PER 51-00-05-1 AND PRINT 147A5712-41.SDR AALA20171030004Floorbeam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON FLOORBEAM UPPER CHORD AT FUSELAGE STATION 986.5 BETWEEN LBL54 AND RBL54. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-4 ALTERNATIVE 1.SDR AALA20171030001Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON AFT FLOOR SUPPORT ANGLE AT FUSELAGE STATION 500I BETWEEN LBL24 AND RBL24. REMOVED AND REPLACED LOWER RAIL ASSEMBLY (FLOOR SUPPORT) PER SRM 51-40-02.SDR AALA20171027004Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON LEFT TRANSITION PANEL BETWEEN FUSELAGE STATIONS 480 AND 500I AT LBL24. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA20171023010Floor Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CRACK ON CABIN FLOOR STRUCTURE AT FUSELAGE STATION 540, LBL3. REMOVED AND REPLACED FLOOR SUPPORT PER AARD 51-00-05-1 AND DRAWING 143A5240.SDR AALA20171023009Floor Support · crackedCRACK ON CABIN FLOOR SUPPORT BS 540, RBL 3. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 143A5240.SDR AALA20171023005Transition Panel · corrodedCORROSION ON THE AFT CARGO, RIGHT TRANSITION PANEL BETWEEN BS 727 AND 767. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, SRM 51-10-02-0G PARAGRAPH 9, AND 51-00-05.SDR AALA20171023004Transition Panel · corrodedCORROSION ON THE AFT CARGO, LEFT TRANSITION PANEL BETWEEN BS 727 AND 847. REMOVED AND REPLACED TRANSITION PANEL IAW SRM 53-00-53-2R, SRM 51-10-02-0G PARAGRAPH 9, AND 51-00-05.SDR AALA20171023001Stiffener · corrodedCORROSION ON LOWER HORIZONTAL STIFFENER ON THE LT APU BAY WEB BETWEEN BS 1090 AND 1098. REMOVED AND REPLACED THE STIFFENER IAW SRM 51-10-02-0G, PARAGRAPH 9, DRAWINGS 148A1684 AND 148A8600.SDR AALA20171020008Transition Panel · corrodedCORROSION FOUND ON THE RIGHT FORWARD CARGO TRANSITION PANEL LOWER MAIN SILL SHIELD BETWEEN BS 420 AND 440, RBL 24. REMOVED AND REPLACED THE TRANSITION PANEL IAW 51-00-05-1 AND DRAWING 143A8126.SDR AALA20171019010Transition Panel · corrodedCORROSION ON THE RIGHT TRANSITION PANEL JUST FORWARD OF THE CARGO DOOR CUTOUT, AROUND THE NUTPLATES, BETWEEN BS 767 AND 787. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 51-40-02, SRM 53-60-15-0I, AND DRAWING 146A8127.SDR AALA20171019009Rib · crackedCRACKED RIGHT HORIZONTAL STABILIZER MACHINED IN SPAR RIB, FOURTH VERTICAL STIFFENER AT THE BOTTOM OF HSS 92.70. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA20171019008Rib · crackedCRACKED RIGHT HORIZONTAL STABILIZER MACHINED IN SPAR RIB, THIRD VERTICAL STIFFENER AT THE BOTTOM OF HSS 92.70. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA20171019007Rib · crackedCRACKED RIGHT HORIZONTAL STABILIZER MACHINED IN SPAR RIB, SECOND VERTICAL STIFFENER AT THE BOTTOM OF HSS 92.70. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA20171019006Rib · crackedCRACKED LEFT HORIZONTAL STABILIZER MACHINED IN SPAR RIB, SECOND VERTICAL STIFFENER AT THE BOTTOM OF HSS 92.70. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA20171019005Rib · crackedCRACKED LEFT HORIZONTAL STABILIZER MACHINED IN SPAR RIB, FIRST VERTICAL STIFFENER AT THE BOTTOM OF HSS 92.70. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA20171019004Transition Panel · corrodedCORROSION ON THE FORWARD CARGO RIGHT AFT TRANSITION PANEL BETWEEN BS 490 AND 500A, RBL 24. REMOVED AND REPLACED THE TRANSITION PANEL IAW SRM 51-00-05-1, AND DRAWING 143A8126.SDR AALA20171018006Web · corrodedCORROSION ON THE AFT CARGO LOWER DOOR SILL WEB BETWEEN BS 793 AND 837. REMOVED AND REPLACED THE WEB IAW SRM 51-40-02, SRM 51-00-05, AND DRAWING 146A8123.SDR AALA20171018005Cargo Track · corrodedCORROSION WAS FOUND ON THE AFT CARGO TRACK ATTACHMENT, RBL13.8, NEAR BS 792. REMOVED AND REPLACED THE CARGO TRACK FROM BS 767 TO 887 IAW SRM 53-00-53-2R, SRM 51-00-05, DRAWING 146A7500, AND EA B737-53-021571, REV B.SDR AALA20171016005Bulkhead Web · crackedCRACK INDICATIONS ON PRESSURE BULKHEAD WEB AT BS 663, BETWEEN RBL 32 AND RBL 34. REPAIRED THE BULKHEAD WEB IAW SRM 57-10-10-2R-3 ALTERNATIVE 1.SDR AALA20171015002Transition Panel · corrodedCORROSION ON FORWARD CARGO RIGHT TRANSITION PANEL BETWEEN BS 500A & 500B, RBL 24. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA20171014005Stiffener · corrodedCORROSION ON VERTIICAL STIFFENER AT BS 1125, APU INLET. REMOVED AND REPLACED THE STIFFENER IAW SRM 51-10-02, AND DRAWING 148A8650.SDR AALA20171012006Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 294 - 328, LBL 45.6. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-00-05-1, SRM 51-40-02, AND DRAWING 141A5410.SDR AALA20171012005Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 328 - 344, LBL 45.6. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-00-05-1, SRM 51-40-02, AND DRAWING 141A5410.SDR AALA201706199065Indicator · faultyFLAPS SPLIT BETWEEN UP AND 1. FLAPS WOULD NOT MOVE EITHER DIRECTION. THE FLIGHT DECLARED AN EMERGENCY AND RECEIVED EXTENDED VECTORS. THE FLIGHT LANDED WITH LE DEVICES EXTENDED BY ALTERNATE MEANS AND FLAPS UP. NO FURTHER INCIDENTS. MAINTENANCE T/S PER FIM 27-51SDR AALA201706169048Transmitter · faultyFLAPS BINDING BETWEEN 1 AND 2 DEGREES WHEN EXTENDING FOR LANDING. ALL LE DEVICES EXTENDED AND GREEN. TE FLAP NEDDLES NOT SPLIT. UNABLE TO MOVE TE FLAPS BY ALTERNATE FLAP SWITCH IAW CHECKLIST TO 15 DEGREES. THE FLIGHT DECLARED AN EMERGENCY. USED FLAP ASYMMETRYSDR AALA201706029042Apu · failedLOUD BANG HEARD COMING FROM APU FOLLOWED BY APU AUTO SHUT DOWN. FAULT LIGHT ILLUMINATED. DID NOT TRY RESTART FLAMES AT TAILPIPE. R & R THE APU IAW MCM 49-94-11. OPS CHECK AND LEAK CHECK GOOD.
Back to N931AN