N747AS
Service difficulty reports not matched to an aircraft · 202
They name N747AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N747AS' AND registry_match IS NULL 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 = 'N747AS' AND registry_match IS NULL 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 ASAA0110201Intercostal · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 500B-520, STRINGER 25L-26L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110165Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 500B, RIGHT BUTTOCK LINE 24, LEFT BUTTOCK LINE 44, CORRODED. REPAIRED PER EA. (M)
Back to N747AS