N14358, cancelled Mar 21, 2013
Service difficulty reports · 53
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 = 'N14358' AND deregistration_id = 'N14358-2013-03-21' 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 = 'N14358' AND deregistration_id = 'N14358-2013-03-21' 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 CALA9700993Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT STA 328 TO 344, BBL 0 TO LBL 45. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-2.SDR CALA9700992Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT STA 312L TO 312R. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR CALA9600927Hyd Line · leakingTHE A-SYSTEM HYDRAULIC FLUID QUANTITY WENT TO ZERO WHILE ON FINAL APPROACH TO EWR. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE NOSE GEAR ACTUATOR HYDRAULIC PRESSURE LINE LEAKING. THE HYDRAULIC PRESSURE LINE WAS REMOVED AND REPLACED. THE GEA
Back to N14358, cancelled Mar 21, 2013