N945AN
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 = 'N945AN' 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 = 'N945AN' 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 AALA200801217Light · malfunctionedMIA INFLIGHT T1409/05MAY - CREW REPORTED EMERGENCY LIGHTS IN THE ARMED POSITION. EMERGENCY LIGHTS STAYED ON IN THE MAIN CABIN IN FLIGHT. RESET EMERGENCY LIGHT CIRCUIT BREAKER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800927Light · damagedDFW - EMERGENCY LIGHT AT AFT NUMBER THREE GALLEY DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT AFT NUMBER THREE GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800926Lens · missingDFW - EMERGENCY LIGHT AT FORWARD GALLEY AISLE MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FORWARD GALLEY AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800925Battery Pack · inoperativeDFW - EMERGENCY EXIT LOCATOR LIGHT AT RIGHT FORWARD OVERWING INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LOCATOR LIGHT AT RIGHT FORWARD OVERWING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800070Battery Pack · inoperativeTUL - EMERGENCY SEAT MOUNTED LIGHTS AT RIGHT SEAT ROWS 22 TO 28 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY SEAT MOUNTED LIGHTS AT RIGHT SEAT ROWS 22 TO 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800071Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT RIGHT FIRST CLASS AND FORWARD SERVICE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT RIGHT FIRST CLASS AND FORWARD SERVICE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800072Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT RIGHT SEAT ROWS 15 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT RIGHT SEAT ROWS 15 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070733Battery Pack · inoperativeLGA - EMERGENCY FLASHLIGHT AT AFT RIGHT INBOARD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY FLASHLIGHT AT AFT RIGHT INBOARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070732Battery Pack · inoperativeLGA - EMERGENCY FLASHLIGHT AT AFT LEFT INBOARD INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY FLASHLIGHT AT AFT LEFT INBOARD. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070731Battery Pack · inoperativeLGA - EMERGENCY FLASHLIGHT AT FORWARD JUMPSEAT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY FLASHLIGHT AT FORWARD JUMPSEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061189Lens · missingDFW - EMERGENCY PATH LIGHT AT SEAT 26D HAS LENS MISSING. REPLACED LENS FOR EMERGENCY PATH LIGHT AT SEAT 26D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060346Battery Pack · dischargedTUL - EMERGENCY LIGHT BATTERY PACK ROWS 15 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR FOR EMERGENCY LIGHTS AT ROWS 15 TO 21. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060347Battery Pack · dischargedTUL - EMERGENCY LIGHT BATTERY PACK AT FORWARD CABIN AND FORWARD ENTRY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN AND FORWARD ENTRY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050538Light · inoperativeTUL - EMERGENCY LIGHT ON FORWARD SERVICE DOOR ESCAPE SLIDE INOPERATIVE NOT HOOKED UP. INSTALLED SERVICEABLE SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040800Battery Pack · inoperativeMIA - EMERGENCY LIGHTS AT SEATS 27D TO BACK OF CABIN INOPERATIVE. REPLACED BATTERY PACK FOR AFT EMERGENCY LIGHTS FROM SEATS 27D TO BACK OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040261Battery Pack · dischargedSFO - EMERGENCY LIGHTING AT SEAT ROWS 7 THROUGH 10D INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTING AT SEAT ROWS 7 THROUGH 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N945AN