N927AN
Service difficulty reports · 180
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 = 'N927AN' 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 = 'N927AN' 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 AALA20111117TUL06Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 400L. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111117TUL04Frame · crackedCRACK INDICATED IN FRAME AT AC RAIL ATTACH BRACKET AT STATION 380. FRAME REPAIRED PER ECO J1159AD.SDR AALA20111116TUL07Angle · crackedCRACKED ANGLE AT AUXILIARY POWER UNIT TORQUE BOX LEFT SIDE WALL UPPER ANGLE. REPLACED ANGLE PER SRM 51-10-02.SDR AALA20111119TUL07Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 312 RIGHT BUTTLINE 20. INSTALLED REPAIR DOUBLER PER 53-00-51-2R REPAIR 1.SDR AALA20111119TUL06Intercostal · corrodedINTERCOSTAL CORRODED AT STATION 305 RIGHT BUTTLINE 10. REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA20111119TUL05Intercostal · gougedINTERCOSTAL HAS TOOLING GOUGE IN RADIUS AT STATION 321 LEFT BUTTLINE 45. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20111117TUL16Intercostal · crackedINTERCOSTAL CRACKED AT FASTENER HOLES STATIONS 285 AND 291 BUTTLINE 0. REPLACED INTERCOSTAL PER SRM 51-10-02-OG.SDR AALA20111116TUL06Stiffener · corrodedCORROSION AROUND AUXILIARY POWER UNIT INLET STRUCTURE STATION 1121. INSTALLED STIFFENER TO AFT SIDE OF APU INLET STATION 1121 PER BOEING DOCUMENT NUMBER 148A8650 AND AARD 51-00-05.SDR AALA20110608TUL06Intercostal · crackedINTERCOSTAL CRACKED BELOW CABIN FLOOR, STATIONS 328 TO 344 LEFT BUTTLINE 44. INSTALLED NEW INTERCOSTAL PER AARD 51-00-00-1.SDR AALA20110607TUL07Intercostal · crackedEMERGENCY EQUIPMENT BAY INTERCOSTAL CRACKED BELOW CABIN FLOOR AT STATIONS 312 TO 328 AND LEFT BUTTLINE 44. REMOVED AND REPLACED THE INTERCOSTAL PER AARD 51-00-00-1.SDR AALA20110611TUL01Bulkhead · corrodedSTATION 1088 BULKHEAD HAS CORROSION IN AREA OF AUXILIARY POWER UNIT INLET DUCT. UPPER ANGLE REPLACED ON APU INLET STATION 1088 PER AARD 51-10-05 AND EA 737-53-017392.SDR AALA20110309MIA01Sensor · faultyMIA - CREW REPORTED LEADING EDGE FLAPS TRANSIT NUMBER 4 LEADING EDGE LIGHT BEGAN GOING ON AND OFF. FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER 4 LEADING EDGE FLAP EXTEND SENSOR. SYSTEM GROUND CHECK NORMAL OPESDR AALA20101012TUL06Switch · obstructedBWI - CREW REPORTED CARGO DOOR WARNING INDICATION ON CLIMBOUT. EMERGENCY DECLARED RETURNED BWI LANDED WITHOUT INCIDENT. FOUND METAL HOOK IN MICRO SWITCH. REMOVED OBSTRUCTION AND AFT CARGO DOOR LIGHT WENT OUT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100719TPA01Battery Pack · dischargedFOUND TWO OVERHEAD BIN EMERGENCY LIGHTS INOPERATIVE ON FUNCTIONAL CHECK CARD 2904. REPLACED BATTERY PACK AND REALIGNED LIGHT CONTACT AT ROW 9DEF. OPS CHECKED NORMAL.SDR AALA20100225TUL13Pin · pulledEMERGENCY LIGHT AT SEAT 23D INOPERATIVE. REPLACED PULLED OUT PIN AT SIDEWALL CONNECTOR.SDR AALA20100122MIA01Module · failedEMERGENCY LIGHTS AT SEATS 7D TO 11D INOPERATIVE. REPLACED MODULE M1676.SDR AALA2009080100001Battery Pack · dischargedMIA - EMERGENCY LIGHT AT LEFT OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR LEFT OVERWING EMERGENCY LIGHT.SDR AALA20071053Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK ABOVE FORWARD ENTRY LIGHT FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK ABOVE FORWARD ENTRY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071054Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK ABOVE FORWARD ENTRY LIGHT FAILED OPERATIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK ABOVE FORWARD ENTRY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071004Battery Pack · inoperativeTUL - EMERGENCY LIGHT AT FORWARD ENTRY DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT FORWARD ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070073Fan · looseSJO INFLIGHT T2164/13JAN - CABIN PRESSURIZATION LOSS. EMERGENCY DECLARED. LANDED SJO WITHOUT INCIDENT. NO MASKS DEPLOYED. FOUND GASPER FAN AT 23B LOOSE. SECURED GASPER FAN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061297Bulb · burned outMIA - OVERHEAD EMERGENCY LIGHT AT SEAT 15C INOPERATIVE. RELAMPED OVERHEAD EMERGENCY LIGHT AT SEAT 15C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061162Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 12D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061163Socket · missingMIA - EMERGENCY LIGHT AT SEAT 12D HAS BEZEL MISSING. REPLACED MISSING BEZEL FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060711Oxygen Mask · unwanted deployDFW - DURING TAKEOFF OXYGEN MASKS AT SEATS 27DEF DROPPED. SEATS WERE VACANT. LANDED DFW WITHOUT INCIDENT. STOWED OXYGEN MASKS AND PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060473Pseu · inoperativeMIA - AFTER TAKEOFF LANDING GEAR WOULD NOT RETRACT. FLIGHT DIVERTED TO MIA AND LANDED WITHOUT INCIDENT. REPLACED PROXIMITY SWITCH ELECTRONICS UNIT AND LANDING GEAR TRANSFER VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050830Battery Pack · failedTUL - CABIN EMERGENCY LIGHT BATTERY PACKS FAILED DRAIN TEST. REPLACED BATTERY PACKS FOR CABIN EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040807Slide · puncturedTUL - EMERGENCY ESCAPE SLIDE HAS APPROXIMATELY 0.25 INCH HOLE CAUSING SLIDE TO DEFLATE. SLIDE SENT TO SHOP FOR REPAIR. REPLACED SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040798Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACKS IN CABIN FAILED 15 MINUTE MINIMUM TIME PER CARD 2311. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20020801Engine · malfunctionedMSY - FLT 978 - MIA-IAH - EN ROUTE IAH AT CRUISE, RT ENGINE LOST POWER ASSOCIATED WITH VIBRATION. PILOT DECLARED EMERGENCY AND LANDED MSY WITHOUT INCIDENT. TOWER REPORTED RIGHT ENGINE ON FIRE. EMERGENCY EVACUATION INITIATED. THERE WERE NO ENGINE FIRE WARNI
Back to N927AN