N799AN
Service difficulty reports · 272
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 = 'N799AN' 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 = 'N799AN' 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 AALA200800218Battery Pack · inoperativeDFW - EMERGENCY LIGHTS AT LEFT AND RIGHT SEAT ROWS 1 TO 4 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT AND RIGHT SEAT ROWS 1 TO 4. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800216Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 55C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800215Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 44C INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 44C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800214Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800217Light · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT R3 DOOR INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EXTERIOR EMERGENCY LIGHT AT R3 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072395Window · crackedLGW INFLIGHT T173/07DEC - CAPTAINS LEFT NUMBER ONE WINDSHIELD ARCED AND CRACKED. RETURNED TO LGW AND LANDED WITHOUT INCIDENT. REPLACED WINDOW AND REPLACED HEAT CONTROLLER AS PRECAUTION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071719Battery Pack · inoperativeJFK - EMERGENCY LIGHT IN COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070131Bulb · burned outDFW - EMERGENCY EXIT LIGHT AT SEAT 26G INOPERATIVE. RELAMPED EMERGENCY EXIT LIGHT AT SEAT 26G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070130Bulb · burned outDFW - EMERGENCY EXIT LIGHT AT SEAT 39C INOPERATIVE. RELAMPED EMERGENCY EXIT LIGHT AT SEAT 39C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070129Bulb · burned outDFW - EMERGENCY EXIT LIGHT AT SEAT 20C INOPERATIVE. RELAMPED EMERGENCY EXIT LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070128Light · damagedDFW - EMERGENCY EXIT LIGHT AT LEFT FORWARD CORNER OF FORWARD COAT CLOSET DAMAGED. REPLACED EMERGENCY LIGHT ASSEMBLY AT LEFT FORWARD CORNER OF FORWARD COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060526Wire Harness · inoperativePASSENGER ENTERTAINMENT INOPERATIVE. SYSTEM TURNED OFF ROWS 38 TO 43. REPORTED SPARKING NEAR SEAT 40J. REPLACED CABLE ASSEMBLY FOR PASSENGER ENTERTAINMENT SYSTEM AT SEATS 40HJ AND 41HJ. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050747Connector · inoperativeJFK - EMERGENCY LIGHTS FROM ROW 34 AFT LEFT AND RIGHT HAND SIDES INOPERATIVE. FOUND CANNON PLUG AT ROW 34 DISCONNECTED. RESECURED CONNECTOR FOR EMERGENCY LIGHTS FROM ROW 34 AFT ON LEFT AND RIGHT SIDES. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050646Connector · inoperativeLHR - EMERGENCY PATH LIGHTING IN REAR SECTION OF CABIN INOPERATIVE. FOUND PLUG D3204J DISCONNECTED AT SEAT 33C. REFITTED PLUG FOR EMERGENCY PATH LIGHTING IN REAR SECTION OF CABIN AT SEAT 33C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050203Connector · inoperativeDFW - EMERGENCY LIGHTS IN SEAT ROWS 35 TO 40 INOPERATIVE. FOUND EMERGENCY PATH LIGHT CONNECTOR OFF ON SEAT 34 CENTER. INSTALLED CONNECTOR AT SEAT 34 CENTER FOR EMERGENCY LIGHTS IN SEAT ROWS 35 TO 40. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041161Socket · defectiveEXTERIOR EMERGENCY EXIT LIGHTING AT R3 INOPERATIVE. REPLACED SOCKET ASSEMBLY FOR EMERGENCY EXIT LIGHT AT R3. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040664Light · damagedJFK - EMERGENCY LIGHT AT CORNER OF 1L CLOSET DAMAGED. REPLACED EMERGENCY LIGHT ASSEMBLY AT CORNER OF 1L CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030190Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 35HG INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021261Sign · brokenMIA - DURING OVERNIGHT MAINTENANCE, OVERHEAD EMERGENCY ESCAPE EXIT SIGN HOUSING AT 4L DOOR BROKEN. REPLACED EMERGENCY ESCAPE LIGHTING ASSEMBLY OVER CEILING AT 4L DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021133Connector · inoperativeORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY ESCAPE PATH LIGHTS AT 21C INOPERATIVE. TIGHTENED AND RESEATED LOOSE CONNECTOR AT SEAT 21E. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20020566Power Supply · dischargedDFW - DURING OVERNIGHT MAINTENANCE, FOUND R4 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED POWER SUPPLY FOR AT R4. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20012050Idg · failedMIA - FLT 57 - LEFT ELECT GENERATOR FAILED DURING DESCENT. ALSO, GOT ICE DETECTOR LEFT AND ELECT GENERATOR L STATUS MESSAGES. REPLACED LEFT ENGINE IDG, RAN ENGINE, OPS CHECK LEAK CHECK GOOD. (M)
Back to N799AN