N914AN
Service difficulty reports · 216
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 = 'N914AN' 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 = 'N914AN' 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 AALA20090707TUL04Angle · crackedFORWARD CARGO, CLIP ANGLE CRACKED UNDER LEFT TRANSITION PANEL AT STATION 500H. REMOVED AND REPLACED CLIP PER SRM 51-10-02.SDR AALA20090707TUL03Angle · crackedFORWARD CARGO, CLIP ANGLE CRACKED UNDER LEFT TRANSITION PANEL AT STATION 500G. REMOVED AND REPLACED CLIP PER SRM 51-10-02.SDR AALA20090430TUL01Angle · corrodedRIGHT AFT SERVICE DOOR CUTOUT LOWER THRESHOLD CREASE ANGLE HAS AREAS OF CORROSION ALONG ANGLE AT STATION 943 TO STATION 993 AT APPROXIMATELY RIGHT BODY LINE 50 INCHES. CORROSION LEVEL 1. REMOVED AND REPLACED CREASE ANGLE PER SRM 51-00-10 AND EA B737-006138.SDR AALA2009032200635Shroud · brokenDFW - EMERGENCY LIGHT SHROUD AT SEAT 28D BROKEN. REPLACED EMERGENCY LIGHT SHROUD AT SEAT 28D.SDR AALA2009032200634Shroud · brokenDFW - EMERGENCY LIGHT SHROUD FOR SEAT 26D BROKEN. REPLACED EMERGENCY LIGHT SHROUD FOR SEAT 26D.SDR AALA200800650Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 12D TO 14D AND OVERWING HATCH INOPERATIVE. REPLACED BATTERY PACK M1695 FOR EMERGENCY LIGHTS AT SEAT ROWS 12D TO 14D AND OVERWING HATCH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800651Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT SEAT ROWS 13C TO 20C AND LEFT EXTERIOR OVERWING INOPERATIVE. REPLACED BATTERY PACK M1670 FOR EMERGENCY LIGHTS AT SEAT 13C TO 20C AND LEFT EXTERIOR OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072548Light · inoperativeMIA - EMERGENCY LIGHTS AT SEAT ROWS 12D AND 14D INOPERATIVE. RESET EMERGENCY LIGHTS AT SEAT ROWS 12D AND 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072547Light · inoperativeMIA - EMERGENCY LIGHT AT LEFT FORWARD WING EXIT SIGN INOPERATIVE. RESET EMERGENCY LIGHTS AT LEFT FORWARD WING EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071081Cover · missingMIA - EMERGENCY WINDOW LIGHT AT AFT CABIN MISSING COVER. REPLACED EMERGENCY WINDOW LIGHT COVER AT AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071080Lens · missingMIA - EMERGENCY LIGHT AT SEAT 8B HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 8B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071079Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 8B INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 8B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070657Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK AT SEAT 18F FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK AT SEAT 18F. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070656Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN AFT CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050684Battery Pack · inoperativeTUL - BATTERY PACKS IN FIRST CLASS SEATS, AFT GALLEY, AND RIGHT HAND FORWARD COACH INOPERATIVE. REPLACED BATTERY PACKS IN FIRST CLASS SEATS, AFT GALLEY, AND RIGHT HAND FOWARD COACH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040827Skin · damagedTUL - SKIN DAMAGE AND CHORD DAMAGE ON RIGHT HAND FUSELAGE AT COCKPIT IN AREA 32 INCH BY 16 INCH. SKIN DAMAGE IN THREE AREAS. REMOVAL CUTOUTS ARE FIVE AND ONE HALF INCH BY THREE INCH, FOUR AND THREE FOURTH INCH BY 2 INCH AND NINE INCHS BY SEVEN AND ONE HALF I
Back to N914AN