AD 2001-01-01
Registered aircraft · 841
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-01')
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-01')
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-01') 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-01') 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.
N518DDDcs Aviation LLC · Dallas, TXN518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLN519CPAircraft Guaranty Corp Trustee · Oklahoma City, OKN51SETps LLC · Medina, WAN51VETrousdale Aviation LLC · West Hollywood, CAN521GAGulfstream Aerospace Corp · Savannah, GAN524AGTvpx Ars Inc Trustee · North Salt Lake, UTN527JGGibbs International Inc · Spartanburg, SCN528MPCr Holdings LLC · Crystal Lake, ILN529RLRegistered aircraftN530KCRegistered aircraftN530PMEbts LLC · New York, NYN535VDelaware Aircraft Trust LLC Trustee · New Castle, DEN53GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN543GLSkechers USA Inc · Manhattan Beach, CAN543HAir Troxel LLC · Honolulu, HIN549CFAvex Xvii LLC · Ft Lauderdale, FLN549CPSlmf LLC · Blaine, MNN54DPGps 1 LLC · Tampa, FLN550Kendall Road Pegasus LLC · Chicago, ILN550AA711 Cody Inc · Teterboro, NJN550EWW & W Jets LLC · Wichita, KSN550FBI Am Air Trust LLC · Dover, DEN550GW711 Cody Inc · Teterboro, NJN550HQHuck Aviation LLC · Kalispell, MTN550KFWilmington Trust Company Trustee · Wilmington, DEN550LKN550lk LLC · Palo Alto, CAN550RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN550UNAirx G550 LLC · Newark, DEN550VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN551SWSn 9086 LLC · Wilmington, DEN552YMWilmington Trust Co Trustee · Wilmington, DEN553GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN553RBG550 LLC · Reno, NVN554AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN555GATvpx Ars Inc Trustee · North Salt Lake, UTN555HDDkh Services LLC · Salt Lake City, UTN555PVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN557ADGulfstream Flight Holdings LLC · New York, NYN5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN559GGlen Alba Investments Inc Trustee · Wilmington, DEN55BMJet Force V LLC · Fresno, CAN55FVIsh Flight LLC · Bloomfield Hills, MIN55GVTc Business Aviation LLC · San Francisco, CAN560UCsms Management LLC · Pearland, TXN5616Geev LLC · Cartersville, GAN561RLAgile Equipment Leasing LLC · Wilmington, DEN561SKJet Air Management LLC · Miami Beach, FLN562THGlobal One Tjh LLC · San Antonio, TXN563BBGulfstream V 563 LLC · Midland, TX
Back to AD 2001-01-01