AD 2000-11-28
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:2000-11-28')
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-11-28')
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-11-28') 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-11-28') 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.
N353AZCargo Aircraft Management Inc · Wilmington, OHN356KDAtares Funding LLC · Miami Beach, FLN359AZCargo Aircraft Management Inc · Wilmington, OHN362CMCargo Aircraft Management Inc · Wilmington, OHN362UPUnited Parcel Service Co · Louisville, KYN363CMCargo Aircraft Management Inc · Wilmington, OHN363UPUnited Parcel Service Co · Louisville, KYN364CMCargo Aircraft Management Inc · Wilmington, OHN364UPUnited Parcel Service Co · Louisville, KYN367AZCargo Aircraft Management Inc · Wilmington, OHN367SPSamaritan'S Purse · Boone, NCN36NE2/25/94 LLC · Foxboro, MAN371CMCargo Aircraft Management Inc · Wilmington, OHN372CMAirborne Maintenance And Engineering Serives Inc · Wilmington, OHN373CMCargo Aircraft Management Inc · Wilmington, OHN373JXJetonex LLC · Sunny Isles Beach, FLN378CXCargo Aircraft Management Inc · Wilmington, OHN379AZCargo Aircraft Management Inc · Wilmington, OHN389AZCargo Aircraft Management Inc · Wilmington, OHN390CMCargo Aircraft Management Inc · Wilmington, OHN391CMCargo Aircraft Management Inc · Wilmington, OHN391UPCargo Aircraft Management Inc · Wilmington, OHN392UPCargo Aircraft Management Inc · Wilmington, OHN393UPCargo Aircraft Management Inc · Wilmington, OHN394UPCargo Aircraft Management Inc · Wilmington, OHN395CMCargo Aircraft Management Inc · Wilmington, OHN395UPCargo Aircraft Management Inc · Wilmington, OHN396CMCargo Aircraft Management Inc · Wilmington, OHN396UPUnited Parcel Service Co · Louisville, KYN397AZCargo Aircraft Management Inc · Wilmington, OHN397UPUnited Parcel Service Co · Louisville, KYN404KZWilmington Trust Co Trustee · Wilmington, DEN405KZWilmington Trust Co Trustee · Wilmington, DEN406KZWilmington Trust Co Trustee · Wilmington, DEN413CMCargo Aircraft Management Inc · Wilmington, OHN419AZCargo Aircraft Management Inc · Wilmington, OHN423AXOmni Planes LLC · Tulsa, OKN429MCAtlas Air Inc · Purchase, NYN431AZCargo Aircraft Management Inc · Wilmington, OHN432AXCargo Aircraft Management Inc · Wilmington, OHN433AZCargo Aircraft Management Inc · Wilmington, OHN438GTAtlas Air Inc · White Plains, NYN439GTAtlas Air Inc · White Plains, NYN443AZCargo Aircraft Management Inc · Wilmington, OHN455CMCargo Aircraft Management Inc · Wilmington, OHN457AZCargo Aircraft Management Inc · Wilmington, OHN462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN464MCAtlas Air Inc · Purchase, NYN465MCAtlas Air Inc · Purchase, NYN471MCAtlas Air Inc · White Plains, NY
Back to AD 2000-11-28