AD 2001-01-10
Registered aircraft · 282
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:2001-01-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-01-10')
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:2001-01-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-01-10') 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.
N194UAUnited Airlines Inc · Chicago, ILN195DNDelta Air Lines Inc · Atlanta, GAN195UAUnited Airlines Inc · Chicago, ILN196DNDelta Air Lines Inc · Atlanta, GAN197DNDelta Air Lines Inc · Atlanta, GAN197UAUnited Airlines Inc · Chicago, ILN198DNDelta Air Lines Inc · Atlanta, GAN199DNDelta Air Lines Inc · Atlanta, GAN207AXOmni Planes LLC · Tulsa, OKN219CYCargo Aircraft Management Inc · Wilmington, OHN225AXOmni Planes LLC · Tulsa, OKN225NE2/25/94 LLC · Foxboro, MAN227AZCargo Aircraft Management Inc · Wilmington, OHN227CYCargo Aircraft Management Inc · Wilmington, OHN229AZCargo Aircraft Management Inc · Wilmington, OHN233AZCargo Aircraft Management Inc · Wilmington, OHN234AXCargo Aircraft Management Inc · Wilmington, OHN237CMCargo Aircraft Management Inc · Wilmington, OHN239AZCargo Aircraft Management Inc · Wilmington, OHN241AZCargo Aircraft Management Inc · Wilmington, OHN249BABoeing Aircraft Holding Co · Seattle, WAN255CMCargo Aircraft Management Inc · Wilmington, OHN257AZCargo Aircraft Management Inc · Wilmington, OHN263SGAtlas Air Inc · Purchase, NYN267JRKnight Sky II LLC · Miami, FLN269CMCargo Aircraft Management Inc · Wilmington, OHN271CMCargo Aircraft Management Inc · Wilmington, OHN283CMCargo Aircraft Management Inc · Wilmington, OHN290CMCargo Aircraft Management Inc · Wilmington, OHN298CMCargo Aircraft Management Inc · Wilmington, OHN301CRCobra Aviation Services LLC · Oklahoma City, OKN307AZCargo Aircraft Management Inc · Wilmington, OHN311AZCargo Aircraft Management Inc · Wilmington, OHN312AACargo Aircraft Management Inc · Wilmington, OHN313AZCargo Aircraft Management Inc · Wilmington, OHN317AZCargo Aircraft Management Inc · Wilmington, OHN317CMCargo Aircraft Management Inc · Wilmington, OHN319CMCargo Aircraft Management Inc · Wilmington, OHN321CMCargo Aircraft Management Inc · Wilmington, OHN322SGAtlas Air Inc · Purchase, NYN329ZAKalitta Air LLC · Ypsilanti, MIN331AZCargo Aircraft Management Inc · Wilmington, OHN337AZCargo Aircraft Management Inc · Wilmington, OHN337JXJetonex LLC · Sunny Isles Beach, FLN344CMCargo Aircraft Management Inc · Wilmington, OHN344KDAtares Funding LLC · Miami Beach, FLN347AZCargo Aircraft Management Inc · Wilmington, OHN347CMCargo Aircraft Management Inc · Wilmington, OHN349CMCargo Aircraft Management Inc · Wilmington, OHN351CMCargo Aircraft Management Inc · Wilmington, OH
Back to AD 2001-01-10