AD 2011-07-05
Registered aircraft · 351
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-05')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-07-05') ORDER BY n_number
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.
N721ANWilmington Trust Co Trustee · Wilmington, DEN722ANAmerican Airlines Inc · Fort Worth, TXN723ANAmerican Airlines Inc · Fort Worth, TXN724ANAmerican Airlines Inc · Fort Worth, TXN725ANAmerican Airlines Inc · Fort Worth, TXN726ANAmerican Airlines Inc · Fort Worth, TXN727ANAmerican Airlines Inc · Fort Worth, TXN728ANAmerican Airlines Inc · Fort Worth, TXN729ANAmerican Airlines Inc · Fort Worth, TXN730ANAmerican Airlines Inc · Fort Worth, TXN731ANAmerican Airlines Inc · Fort Worth, TXN732ANAmerican Airlines Inc · Fort Worth, TXN733ARAmerican Airlines Inc · Fort Worth, TXN734ARAmerican Airlines Inc · Fort Worth, TXN735ATAmerican Airlines Inc · Fort Worth, TXN736ATAmerican Airlines Inc · Fort Worth, TXN74007United Airlines Inc · Chicago, ILN749BCAlta 777 LLC · Salt Lake City, UTN750ANAmerican Airlines Inc · Fort Worth, TXN751ANAmerican Airlines Inc · Fort Worth, TXN752ANAmerican Airlines Inc · Fort Worth, TXN753ANAmerican Airlines Inc · Fort Worth, TXN754ANAmerican Airlines Inc · Fort Worth, TXN755ANAmerican Airlines Inc · Fort Worth, TXN756AMAmerican Airlines Inc · Fort Worth, TXN757ANAmerican Airlines Inc · Fort Worth, TXN758ANAmerican Airlines Inc · Fort Worth, TXN759ANAmerican Airlines Inc · Fort Worth, TXN76010United Airlines Inc · Chicago, ILN76021United Airlines Inc · Chicago, ILN760ANAmerican Airlines Inc · Fort Worth, TXN761AJAmerican Airlines Inc · Fort Worth, TXN762ANAmerican Airlines Inc · Fort Worth, TXN763ANBoeing Co · Renton, WAN764ANBoeing Co · Renton, WAN765ANAmerican Airlines Inc · Fort Worth, TXN766ANAmerican Airlines Inc · Fort Worth, TXN767AJAmerican Airlines Inc · Fort Worth, TXN768AAAmerican Airlines Inc · Fort Worth, TXN768UAUnited Airlines Inc · Chicago, ILN769UAUnited Airlines Inc · Chicago, ILN77006United Airlines Inc · Chicago, ILN77012United Airlines Inc · Chicago, ILN77014United Airlines Inc · Chicago, ILN77019United Airlines Inc · Chicago, ILN77022United Airlines Inc · Chicago, ILN770ANAmerican Airlines Inc · Fort Worth, TXN771ANAmerican Airlines Inc · Fort Worth, TXN771KWEal Asset Holdings LLC · Kansas City, MON771LGLogistic Air Inc · Reno, NV
Back to AD 2011-07-05