N913AN
Service difficulty reports · 192
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 = 'N913AN' 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 = 'N913AN' 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 AALA20090504TUL05Panel · corrodedAFT CARGO LEFT TRANSITION PANEL HAS CORROSION AT STATION 807 TO 827. REMOVED CORROSION PER SRM 51-10-02. REPAIRED PER SRM 53-00-53.SDR AALA20090504TUL04Panel · corrodedAFT CARGO LEFT TRANSITION PANEL HAS CORROSION AT STATION 787 TO 807. REMOVED CORROSION PER SRM 51-10-02. REPAIRED PER SRM 53-00-53.SDR AALA20090612TUL07Skin · scratchedSCRATCHES ON FORWARD CARGO DOOR ABOUT 18 INCHES TO 20 ABOVE HANDLE. REPLACED CARGO DOOR SKIN PER ESO 60654.SDR AALA20090501TUL06Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 400. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL05Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 480. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL04Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 727B. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL03Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 480. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL02Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 727B. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090501TUL01Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 400. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090430TUL13Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 480. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159AB.SDR AALA20090430TUL12Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 440. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL11Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 400. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL10Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 500A. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL09Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT RIGHT STATION 500C. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL08Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 500F. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL07Frame · crackedCRACK IN FRAME AT FASTENER HOLE AT AIR CONDITIONING RAIL ATTACH POINT AT LEFT STATION 380. LENGTH OF CRACK NOT SPECIFIED BY NDT. REPAIRED PER J1159ABSDR AALA20090430TUL02Frame · crackedCRACK AT FASTENER HOLE ON RIGHT 727B FRAME AT AIR CONDITIONING ATTACH POINT. CRACK LENGTH NOT NOTED BY HHEC INSPECTOR. REPAIRED PER J1159ABSDR AALA20090427TUL14Intercostal · crackedCABIN FLOOR INTERCOSTAL AT STATION 328 TO 344 LEFT BODY LINE 46 INCHES CRACKED AT FASTENER HOLE. INSTALLED NEW INTERCOSTAL PER SRM 53-00-10.SDR AALA20090427TUL13Intercostal · crackedCABIN FLOOR INTERCOSTAL AT STATION 312 TO 328 LEFT BODY LINE 46 INCHES CRACKED AT FASTENER HOLE. INSTALLED NEW INTERCOSTAL PER SRM 53-00-10.SDR AALA20090427TUL01Floorbeam · corrodedCABIN FLOORBOARD SUPPORT BEAM BETWEEN STATION 312 TO 328 HAS CORROSION AT AFT TWO ATTACH FASTENERS 48 INCHES FROM RIGHT SIDEWALL. INSTALLED REPAIR DOUBLER ANGLE AT STATION 328 FLOORBEAM PER SRM 53-00-51-2R. CORROSION LEVEL 1.SDR AALA20090427TUL02Floorbeam · corrodedCABIN FLOORBOARD SUPPORT BETWEEN STATION 312 TO 328 HAS CORROSION AROUND NUT PLATE FASTENER HOLE APPROXIMATELY 48 INCHES FROM RIGHT SIDEWALL. CORROSION LEVEL 1. INSTALLED SERVICEABLE FLOORBOARD SUPPORT PER SRM 51-40-02.SDR AALA20090424TUL03Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM AROUND FASTENER HOLES LEFT OF CENTER LINE OUTBOARD AT STATION 986. CORROSION LEVEL 1. INSTALLED REPAIR DOUBLER AND STRAP PER SRM 53-00-51-2R.SDR AALA2009021201021Overheat Loop · brokenMIA - RIGHT WING BODY OVERHEAT LIGHT ILLUMINATED ON DEPARTURE. EMERGENCY DECLARED AND FLIGHT RETURNED TO MIA WITHOUT INCIDENT. REPLACED LOOPS M371 AND M269 ON RIGHT WING. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA200802072Window · crackedPLS INFLIGHT T1290/11 AUG STX TO MIA. CREW REPORTED LT NR 1 WINDOW CRACKED. LANDED PLS WITHOUT INCIDENT. REPLACED LT NR 1 WINDOW. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200801954Controller · inoperativeJFK INFLIGHT T750/25JUL DFW TO LGA. CREW REPORTED ANTI-SKID INOPERATIVE INDICATION AFTER TAKE OFF. LANDED JFK WITHOUT INCIDENT DUE TO LONGER RUNWAY. REPLACED ANTI SKID AUTO BRAKE CONTROL UNIT. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200800280Sensor · inoperativeDEN INFLIGHT T2281/10FEB - DURING APPROACH FLAP ASYMMETRY OCCURRED AT APPROXIMATELY TWO DEGREES. LANDED DEN WITHOUT INCIDENT. REPLACED NUMBER SIX FLAP SKEW SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071534Bulb · missingLAX - EMERGENCY LIGHT AT SEAT ROW 9D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071533Lens · missingLAX - EMERGENCY LIGHT AT SEAT ROW 9D INOPERATIVE. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070647Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070646Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070645Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070644Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061195Cap · missingMIA - EMERGENCY LIGHT AT SEAT 13A HAS CAP MISSING. REPLACED CAP FOR EMERGENCY LIGHT AT SEAT 13A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20090612TUL04Pan · gougedDOOR HANDLE PAN GOUGED. REPLACED DOOR HANDLE PAN PER ESO 60657.SDR AALA20050568Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN FIRST CLASS CABIN AT STATION 380 TO 400 AND LEFT REAR SERVICE DOOR AT STATION 927 TO 986 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FIRST CLASS CABIN AT STATION 380 TO 400 AND LEFT REAR SERVICE DOOR AT STATION 927 TO SDR AALA20050444Wire · damagedFORWARD RT OUTSIDE EMERGENCY LIGHTS INOPERATIVE. REPAIRED WIRING FOR FORWARD RT OUTSIDE EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040722Battery Pack · inoperativeMIA - EMERGENCY LIGHT AT FORWARD CENTER CEILING AISLE AT ROW 3 IS INOPERATIVE. REPLACED BATTERY PACK M1674 FOR EMERGENCY LIGHT AT FORWARD CENTER CEILING AISLE AT ROW 3. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030361Battery · corrodedDUIRNG OVERNIGHT MAINTENANCE, EMERGENCY EXIT SLIDE LIGHT AT L1 DOOR INOPERATIVE. CLEANED BATTERY CONTACTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030111Light · inoperativeDURING OVERNIGHT MAINTENANCE, LEFT AFT OVERWING EMERGENCY EXIT SIDEWALL LIGHT INOPERATIVE. REPLACED LEFT AFT OVERWING EMERGENCY EXIT SIDEWALL LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20011685Light · inoperativeSNA - DURING OVERNIGHT MAINTENANCE, EXTERIOR EMERGENCY LIGHT AT R1 DOOR INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20011519Light · brokenSNA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE PATH FLOOR LIGHT AT FORWARD GALLEY BROKEN. REPLACED EMERGENCY EXIT ESCAPE PATH FLOOD LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010664Plate · brokenTPA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT LEFT SIDE OVERWING BROKEN. REPLACED EMERGENCY EXIT LIGHT PLATE. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N913AN