N904AN
Service difficulty reports · 263
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 = 'N904AN' 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 = 'N904AN' 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 AALA201812262002Trim Motor · malfunctionedAFTER TAKEOFF, THE PILOT REPORTED A RUNAWAY STABILIZER TRIM CONDITION. AN EMERGENCY WAS DECLARED AND RETURNED TO DEPARTURE, LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE STAB TRIM MOTOR IAW AMM 27-41-71. OPS CHECKED IAW AMM 22-11-81.SDR AALA2018122649001Relay · failedA TRIM RUNAWAY DURING CLIMB, TURNED OFF BOTH STABALIZER TRIMS FOR THE REMAINDER OF THE FLIGHT. DECLARED EMERGENCY INBOUND TO DESTINATION. LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE STABILIZER TRIM CUTOUT RELAY R384 IAW AMM 20-81-22. PSDR AALA201812059025Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT LEFT AFT FLIGHT ATTENDANT JUMPSEAT SHOWED LOSS OF CHARGE. MAINTENANCE REPLACED LEFTHAND AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT BATTERY AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201809289011Battery · dischargedFOWARD FLIGHT ATTENDANT OUTBOARD FLASHLIGHT WAS INOPERATIVE. REPLACED THE FLASHLIGHT BATTERY. OPS CHECKED NORMAL IAW AMM 25-64-00.SDR AALA2018051709006Line · leakingEMERGENCY DECLARED DUE TO AN A SYSTEM HYDRAULIC QUANITY DECREASING AT 1% EVERY 6 MINUTES DOWN TO 37%. LANDED, REPLACED THE AUTOPILOT ELEVATOR HYDRAULIC PRESSURE LINE REDUCER AND O-RING IAW AMM 22-11-26. LEAK AND OPS CHECKED OK. THE AIRCRAFT WAS GROUNDED.SDR AALA201802199016Pin · not seatedFLIGHT DECK DOOR UPPER EMERGENCY EXIT PANEL HAS ONE SLIDE PIN NOT SEATED CORRECTLY. REINSTALLED COCKPIT DOOR PANEL LATCH IAW AMM 52-51-00, CHECKED GOOD.SDR AALA201801199001Lens · missingEXIT SIGN LENS AT FORWARD GALLEY AISLE IS MISSING. REPLACED THE LIGHT ASSEMBLY IN FORWARD AISLE IAW MM 33-51-01.SDR AALA201710049016Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY SEAT 23D IS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201703219047Sign · brokenEXIT SIGN AT RIGHT AFT SVC DOOR BROKEN. REPLACED R2 EMEG EXIT SIGN ASSY IAW AMM 33-51-01. OPS CHECKS NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170302012Skin · crackedA CRACK WAS FOUND IN THE SKIN AT PULLED FASTENER BETWEEN BS 360 - 380 WITH CORROSION ON STRINGER SPLICE AT STRINGER 26L. REPAIRED STRINGER SPLICE PER EA #267695.SDR AALA20170214020Battery · dischargedAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AFT RIGHT SIDE IS FLASHING RED. REMOVED AND REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA20170204003Lens · brokenEMERGENCY EXIT LIGHT NEAR L2 DOOR HAS A BROKEN LENS COVER. REMOVED AND REPLACED EXIT LIGHT IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161129011Cover · missingAIRCRAFT NOT GROUNDED. L2 DOOR EMERGENCY EXIT SIGN COVER IS MISSING. REPLACED THE EXIT SIGN IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20160629003Control Handle · lack of lubeAIRCRAFT WAS GROUNDED. DURING TAKEOFF ROLL THE TAKEOFF CONFIGURATION LIGHT ILLUMINATED ACCOMPANIED BY WARNING HORN AND PSEU LIGHT ILLUMINATION. TAKEOFF ABORTED AT APPROXIMATELY 25 KNOTS. PSEU LIGHT EXTINGUISHED AFTER APPROXIMATELY 5 MINUTES. PSEU SHOWED FASDR AALA20151124004Window Frame · crackedCAPTAINS WINDSHIELD FRAME, UPPER OTBD CORNER CRACKED. INSTALLED REPAIR DOUBLER & TRIPLER IAW AARD 53-10-00-06 & BSB 737-53-1336.SDR AALA20151005006Pressure Panel · crackedMAIN LANDING GEAR WW VERTICAL WEB AT STATION 633.75 HAS CRACKS. INSTALLED DOUBLER REPAIR IAW EA 255081.SDR AALA20150505011Thermostat · failedDURING CLIMB THE RT PACK BLEED FAULTED & WOULDN`T RESET. EMERGENCY DECLARED & FLIGHT LANDED WITHOUT INCIDENT. R & R RT ENGINE 450 DEGREE THERMOSTAT IAW AMM 36-11-05.SDR AALA20150501014Sensor · faultyDURING CLIMB THE RIGHT PACK BLEED FAULTED AND WOULDN"T RESET. EMERGENCY DECLARED AND FLIGHT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED RIGHT ENGINE PRECOOLER CONTROL VALVE SENSOR PER BOEING 737 AMM 36-12-03.SDR AALA20150203014Light · inoperativeL1 DOOR EXIT IDENTIFIER AT THE FWD FLIGHT ATTENDANT SEAT IS INOPERATIVE. R & R IDENTIFIER IAW AMM 35-51-02. SYS CHECKED NORMAL.SDR AALA20141111020Frame · damagedFUSELAGE FRAME CUT INTO AT STATION 787 BETWEEN STRINGERS 20 & 21 LT AT CARGO LOADING BRACKET. REPAIRED FRAME IAW EA B737-53-037292.SDR AALA20141111016Frame · damagedFUSELAGE FRAME CUT INTO AT STATION 727D BETWEEN STRINGER 20 & 21 LT. REPAIRED FRAME IAW EA B737-53-037294 DATED 11 NOV 2014.SDR AALA20141111015Frame · damagedFUSELAGE FRAME CUT INTO AT STATION 727I BETWEEN STRINGER 20 & 21 RT. REPAIRED FRAME IAW EA B737-53-037289 DATED 11 NOV 2014.SDR AALA20141110011Intercostal · corrodedINTERCOSTAL AT FUSELAGE STATION 992 & RBL 32 IS CORRODED. R & R INTERCOSTAL IAW SRM 53-70-51-2R-4.SDR AALA20141110010Angle · corrodedZ ANGLE CORRODED AT FUSELAGE STATION 993 FROM RBL 31 TO RBL 45. R & R Z ANGLE IAW AARD 51-00-05-1.SDR AALA20141110009Web · corrodedFLOOR WEB CORRODED BETWEEN FUSELAGE STATIONS 986.5 & 992 FROM RBL 31 TO RBL 45. R & R WEB DOUBLER IAW SRM 51-70-13-2R-2.SDR AALA20141107018Floor Support · corrodedFLOORBOARD SUPPORT CORRODED BETWEEN FUSELAGE STATIONS 967 & 986.5 AT RBL 16. R & R IAW AARD 51-00-05 REPAIR 1.SDR AALA20141107016Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT FUSELAGE STATION 986.5 & LBL 43. REPAIRED FLOORBEAM IAW EA B737-53-037295 DATED 07 NOV 2014.SDR AALA20141107015Frame · damagedFUSELAGE FRAME CUT INTO AT STATION 727I BETWEEN STRINGER 20 & 21 LT. REPAIRED FRAME IAW EA B737-53-037253 DATED 07 NOV 2014.SDR AALA20141107014Frame · damagedFUSELAGE FRAME CUT INTO AT STATION 727D BETWEEN STRINGERS 20 & 21 RT. REPAIRED FRAME IAW B737-53-037251.SDR AALA20141107013Angle · corrodedRIGHT CREASE ANGLE CORRODED FROM FUSELAGE STATIONS 294 TO 336. R & R CREASE ANGLE IAW SRM 51-40-02.SDR AALA20141107003Skin · corrodedCORROSION ON LOWER CTR WING SKIN RT SIDE UNDER DRAG LINK. REMOVED CORROSION.SDR AALA20141107002Skin · corrodedCORROSION ON LOWER CTR TANK WING SKIN LT SIDE UNDER DRAG LINK. REMOVED CORROSION & REPAIRED AREA IAW ENGINEERING AUTHORIZATION B737-57-037009.SDR AALA20141107001Vapor Barrier · crackedRIGHT VAPOR BARRIER CRACKED. ACCOMPLISHED SRM REPAIR 57-10-10-2R.SDR AALA20141106010Skin · corrodedCORROSION ON SKIN FROM FUSELAGE STATION 917 TO 937 BETWEEN STRINGERS 21 & 23 LT. REMOVED CORROSION & ACCOMPLISHED REPAIR IAW EA B737-53-027457 REV A DATED 29 OCT 2014.SDR AALA20141106004Attach Fitting · crackedFORWARD ATTACH CLIP ON BAFFLE IS CRACKED BETWEEN FUSELAGE STATION 400 & 420 AT STRINGER 25 LT. R & R BAFFLE & ATTACH CLIPS WITH NEW PARTS IAW SRM 51-00-05.SDR AALA20141104008Skin · corrodedCORROSION ON FUSELAGE SKIN BETWEEN STATIONS 887 & 927 FROM STRINGERS 23 LT TO 26 LT. ACCOMPLISHED PERMANENT REPAIR IAW EA B737-53-027457 REV A DATED 29 OCT 2014.SDR AALA20141104001Baffle · crackedCRACK IN RT BAFFLE BETWEEN FUSELAGE STATIONS 500F & 500G. INSTALLED DOUBLER IAW SRM 51-70-11 & AARD 53-00-01-6.SDR AALA20141103003Baffle · crackedBAFFLE AT FUSELAGE STATION 440 - 460 & STRINGER 25 LT CRACKED ON TOP FLANGE. R & R WITH SERVICEABLE BAFFLE.SDR AALA20141102006Skin · damagedFORWARD CARGO DOOR SKIN DAMAGED. DOOR REQUIRES SKIN REPLACEMENT. SKIN WAS REPLACED IAW SRM 52-30-01-1A 2 GENERAL B 2 A & SRM 51-10-02-0G 9 A.SDR AALA20141102004Skin · damagedFORWARD CARGO DOOR SKIN DAMAGED AT AFT EDGE OF 2ND BEAM FROM TOP. INSTALLED DOUBLER & FILLER IAW SRM 52-00-01-2R REPAIR 2 & ENGINEERING AUTHORIZATION COMP-52-037186 DATED 10/30/2014.SDR AALA20141102003Door Frame · gougedFORWARD CARGO DOOR UPPER FRAME GOUGED IN SECOND BAY FROM FWD SIDE AT SECOND FROM AFT MOST RIVET. REPAIRED IAW SRM 51-70-12-2R & ENGINEERING AUTHORIZATION COMP-52-037117 DATED 10-27-2014.SDR AALA20141102002Floorbeam · damagedFLOORBEAM DAMAGED AT FUSELAGE STATION 360 & RBL 11. DAMAGE REMOVED BY BLENDING, FLOORBEAM REPAIR ANGLE INSTALLED IAW SRM 53-00-51-2R-1 WITH DEVIATION IAW AARD 53-00-00-7.SDR AALA20141031001Floorbeam · damagedFLOORBEAM AT STATION 344 & RBL 11 DAMAGED. ACCOMPLISHED NESTED ANGLE REPAIR IAW AARD 53-00-00-7.SDR AALA20141030007Skin · dentedAFT CARGO DOOR OUTER DOOR SKIN HAS SEVERAL DENTS & SCRATCHES. REMOVED OLD SKIN & REPLACED WITH A NEW ONE IAW AARD 51-00-05-1 REPAIR 1.SDR AALA20141028009Angle · corrodedZ ANGLE FROM STATIONS 991 TO 1016 & LBL 31 CORRODED ON UNDERSIDE OF UPPER FLANGE AT STATION 991. REMOVED UNSERVICEABLE Z ANGLE & INSTALLED SERVICEABLE Z ANGLE IAW AARD 51-10-05-1.SDR AALA20141024016Intercostal · corrodedINTERCOSTAL CORRODED AT STATION 310 & RBL 11. INSTALLED NEW INTERCOSTAL FROM STATIONS 294 TO 312 IAW AARD 51-00-05-1 & SRM 52-41-02.SDR AALA20141024014Intercostal · crackedINTERCOSTAL CRACKED BETWEEN FUSELAGE STATION 328 & 344 AT LBL 46. INSTALLED NEW INTERCOSTAL BETWEEN FUSELAGE STATION 328 & 344 AT LBL 46 IAW AARD 51-10-05.SDR AALA20141024013Intercostal · crackedINTERCOSTAL CRACKED BETWEEN FUSELAGE STATION 312 & 328 AT LBL 46. INSTALLED NEW INTERCOSTAL BETWEEN FUSELAGE STATION 312 & 328 AT LBL 46 IAW AARD 51-10-05.SDR AALA20141105004Baffle · crackedFORWARD CARGO RT BAFFLE BETWEEN FUSELAGE STATION 500F & 500G WAS FOUND CRACKED AT A FASTENER HOLE ON THE TOP AFT CORNER. R & R BAFFLE IAW AARD 53-00-01.SDR AALA20141109006Angle · corrodedAFT CARGO COMPARTMENT LT TRANSITION Z ANGLE IS CORRODED BETWEEN FUSELAGE STATIONS 727G & 847 AT LBL 21. R & R TRANSITION ANGLE IAW SRM 53-00-53.
Back to N904AN