N947NN
Service difficulty reports · 109
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 = 'N947NN' 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 = 'N947NN' 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 AALA201906119006Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-64-00.SDR AALA201902219006Megaphone · inoperativeAIRCRAFT WAS GROUNDED: AFT MEGAPHONE INOPERABLE. MAINTENANCE REPLACED AFT GALLEY MEGAPHONE PER AMM 25-64-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201711089002Bleed Valve · failedON TAKEOFF, AFTER BOTH ENGINES WERE STABILIZED AT 40%, TAKEOFF POWER APPLIED AND AIRCRAFT DRIFTED TO THE RIGHT NEARLY OFF THE RUNWAY. RETURNED TO THE GATE. ACCOMPLISHED #2 ENGINE IS SLOW TO ACCELERATE FAULT ISOLATION PER FRMFIM 73-05-00-810-814-F00. DRAINEDSDR AALA201708169018Slide · low pressureAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE PRESSURE IS LOW. REMOVED AND REPLACED SLIDE PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA201706069013Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. LENS COVER MISSING FROM ROW 3E/F AFT EMERG LIGHT. INSTALLED SERVICEABLE LENS AT AFT EMERG LIGHT ROW 3E/F AS REQUIRED PER CARD 2904.SDR AALA201705169018Lens · missingEMERGENCY EXIT LIGHT BY THE R4 DOOR HAS A MISSING LENS. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201704039032Cover · missingEXIT SIGN COVER IS MISSING AT 578. REPLACED LIGHT ASSY L1190 IAW AMM 33-51-01. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20141231001Light · inoperativeR1 DOOR EMER LIGHT INOPERATIVE. RELAMPED R1 DOOR EMER LIGHT IAW AMM 33-51-04. OPERATIONS NORMAL.SDR AALA20140729001Lens · brokenRIGHT AFT EXIT IDENTIFIER L1191 BROKEN. REPLACED LENS FOR RT AFT EXIT IDENTIFIER. OPERATIONS CHECKED NORMAL.
Back to N947NN