AD 2000-15-16
Registered aircraft · 1,709
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:2000-15-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-16')
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:2000-15-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-15-16') 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.
N199ANAersale Inc · Doral, FLN199DNDelta Air Lines Inc · Atlanta, GAN199FEFederal Express Corp · Memphis, TNN200NVAmerican Airlines Inc · Fort Worth, TXN204UAUnited Airlines Inc · Chicago, ILN206UAUnited Airlines Inc · Chicago, ILN207AXOmni Planes LLC · Tulsa, OKN209UAUnited Airlines Inc · Chicago, ILN210UAUnited Airlines Inc · Chicago, ILN21108United Airlines Inc · Chicago, ILN211UAUnited Airlines Inc · Chicago, ILN212UAUnited Airlines Inc · Chicago, ILN213UAUnited Airlines Inc · Chicago, ILN213USMuseum Of Flight Foundation · Seattle, WAN214UAUnited Airlines Inc · Chicago, ILN215UAUnited Airlines Inc · Chicago, ILN216UAUnited Airlines Inc · Chicago, ILN21723United Airlines Inc · Chicago, ILN217UAUnited Airlines Inc · Chicago, ILN218UAUnited Airlines Inc · Chicago, ILN219CYCargo Aircraft Management Inc · Wilmington, OHN219UAUnited Airlines Inc · Chicago, ILN220UAUnited Airlines Inc · Chicago, ILN221UAUnited Airlines Inc · Chicago, ILN222UAUnited Airlines Inc · Chicago, ILN223UAUnited Airlines Inc · Chicago, ILN224UAUnited Airlines Inc · Chicago, ILN225AXOmni Planes LLC · Tulsa, OKN225NE2/25/94 LLC · Foxboro, MAN225PGAero 7 LLC · Doral, FLN225UAUnited Airlines Inc · Chicago, ILN226UAUnited Airlines Inc · Chicago, ILN227AZCargo Aircraft Management Inc · Wilmington, OHN227CYCargo Aircraft Management Inc · Wilmington, OHN227UAUnited Airlines Inc · Chicago, ILN228UAUnited Airlines Inc · Chicago, ILN229AZCargo Aircraft Management Inc · Wilmington, OHN229UAUnited Airlines Inc · Chicago, ILN233AZCargo Aircraft Management Inc · Wilmington, OHN234AXCargo Aircraft Management Inc · Wilmington, OHN23707United Airlines Inc · Chicago, ILN23708United Airlines Inc · Chicago, ILN23721United Airlines Inc · Chicago, ILN237CMCargo Aircraft Management Inc · Wilmington, OHN239AZCargo Aircraft Management Inc · Wilmington, OHN24089Ploutz Lloyd · Modesto, CAN241AZCargo Aircraft Management Inc · Wilmington, OHN24202United Airlines Inc · Chicago, ILN24211United Airlines Inc · Chicago, ILN24212United Airlines Inc · Chicago, IL
Back to AD 2000-15-16