N411AN
Service difficulty reports · 57
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 = 'N411AN' 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 = 'N411AN' 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 AALA202202221615Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FIRST OFFICER'S SIDEWALL FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY,.SDR AALA202201218732Slide · out of positionAIRCRAFT WAS GROUNDED: L3 DOOR OFF-WING ESCAPE SLIDE/RAFT ASSEMBLY PROTRUDING OUT AND NOT FLUSH WITH FUSELAGE. REPLACED L3 EMERGENCY EXIT DOOR SLIDE ENCLOSURE PER JOB CARD 26L00025012.SDR AALA202201033271Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT HANGING ON GROUND SEAT 13C. REATTACHED EMERGENCY EXIT LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202112309775Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT INBOARD FLIGHT ATTENDANT FLASHLIGHT WON'T TEST. REPLACED FLASHLIGHT ASSEMBLY. OPERATIONS NORMAL. JOB CARD 26C00025003.SDR AALA202112308653Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD OUTBOARD FLIGHT ATTENDANT FLASHLIGHT WON'T TEST. REPLACED BATTERY OPERATIONS GOOD JOB CARD 26C00025003.SDR AALA202108307324Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: CAPTAIN SIDEWALL MOUNTED FLASHLIGHT INOPERATIVE. REPLACED CAPTAINS FLASHLIGHT BATTERY PER AMM 33-51-19SDR AALA202103059017Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: THE FLASHLIGHT ON THE CAPTAINS SIDEWALL IS VERY DIM, AND DID NOT SEEM TO CHARGE AT ALL ON A 5 HOUR FLIGHT. REMOVED AND REPLACED FLASHLIGHT CAPTAINS SIDEWALL PER AMM 25-66-00
Back to N411AN