N912AN
Service difficulty reports · 220
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 = 'N912AN' 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 = 'N912AN' 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 AALA20090521TUL19Support · crackedFORWARD CARGO, ANGLE SUPPORT CRACKED FRONT SIDE AT Z ANGLE LEFT SIDE STATION 500H. REPLACED ANGLE SUPPORT SRM 51-10-02.SDR AALA20090521TUL03Intercostal · crackedCABIN FLOORBOARD INTERCOSTAL CRACKED STATION 277 TO 294 BODYLINE 0. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02SDR AALA20090520TUL15Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED STATION 957.5 A RIGHT BODYLINE 26. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02.SDR AALA20090520TUL01Support Angle · crackedFWD CARGO SUPPORT ANGLE CRACKED FRONT SIDE AT Z ANGLE LT SIDE STATION 500G. REPLACED FORWARD CARGO SUPPORT ANGLE FRONT SIDE AT Z ANGLE PER SRM 51-10-02.SDR AALA20090521TUL18Floorbeam · corrodedCABIN FLOORBEAM CORRODED STATION 967 LEFT BODYLINE 16. INSTALLED DOUBLER PER AARD 53-00-00-7.SDR AALA20090521TUL17Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT UPPER FLANGE STATION 986.5 RIGHT BODYLINE 23 AND RIGHT BODYLINE 29.SDR AALA20090521TUL16Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT UPPER FLANGE STATION 986.5 RIGHT BODYLINE 4. REMOVED CORROSION AND INSTALLED DOUBLER PER AARD 53-00-00-8.SDR AALA20090521TUL15Intercostal · crackedCABIN INTERCOSTAL CRACKED AT FASTENER HOLE STATION 312 TO 328 RIGHT BODYLINE 22. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02-06.SDR AALA200802309Lens · missingTPA EMERGENCY LIGHT AT SEAT 19D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802310Lamp · missingTPA EMERGENCY LIGHT AT SEAT 16D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802308Lamp · missingTPA EMERGENCY LIGHT AT SEAT 19D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802307Lens · missingTPA EMERGENCY LIGHT AT SEAT 7D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802306Lamp · missingTPA EMERGENCY LIGHT AT SEAT 7D MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200800785Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED OPERATIONAL CHECK. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800784Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED OPERATIONAL CHECK. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070396Relay · inoperativeIAH INFLIGHT T2163/24FEB - AFTER TAKEOFF LEFT TANK CONFIGURATION LIGHT ILLUMINATED. BOTH LEFT FUEL PUMPS BOTH RIGHT BOOST FUEL PUMPS AND RIGHT CENTER FUEL PUMP WAS ON. LEFT CENTER PUMP AS PLACARDED INOPERATIVE AND OFF. COULD NOT MAINTAIN BALANCE USING STANDSDR AALA20050329Connector · defectiveDFW - EMERGENCY PATH LIGHTING AT SEAT 7D INOPERATIVE. FOUND BAD CONNECTOR AT HARNESS IN SIDEWALL OF 7D. REPLACED EMERGENCY PATH LIGHT AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20010603Socket · defectiveORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT ROW 18 INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT SOCKET AT ROW 18. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010009Skin · bird strikeTUL - FOUND DENT IN HORIZONTAL STAB LEADING EDGE 133.15 TO 198.23, BIRD STRIKE. REPAIRED DENT PER SRM 51-10-02. INSTALLED DOUBLER PER SRM 55-10-01 PAGE 201-206. INSTALLED LEADING EDGE PER ESO 61000 DATED 12-19-2000. (M)SDR AALA20010010Strap · crackedTUL - RIGHT HORIZONTAL STAB LEADING EDGE RIB STRAP CRACKED AT AFT UPPER FASTENER HOLE, STATION 120. REPLACED STRAP PER BOEING DRAWING NR 186A1230. REPAIRED PER SRM 51-40-00. (M)
Back to N912AN