AD 2011-22-01
Registered aircraft · 1,167
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-22-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:2011-22-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:2011-22-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:2011-22-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.
N5524Avpro Inc · Annapolis, MDN552HADepartment Of Defense Missile Defense Agency · Tulsa, OKN552MWSchweitzer Aircraft Leasing Inc · Pullman, WAN552SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN552YMWilmington Trust Co Trustee · Wilmington, DEN553GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN553HADepartment Of Defense Missile Defense Agency · Tulsa, OKN553RBG550 LLC · Reno, NVN553SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN554AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN554DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN554SNTvpx Trust Co LLC Trustee · North Salt Lake, UTN555GATvpx Ars Inc Trustee · North Salt Lake, UTN555HDDkh Services LLC · Salt Lake City, UTN555KHRegian Services LLC · Encino, CAN555PVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN5569Landmark Graphics Corp · Houston, TXN557ADGulfstream Flight Holdings LLC · New York, NYN5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN559DWTvpx 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, CAN55QCQuikrete Aircraft Leasing LLC · Atlanta, GAN560UCsms 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, TXN565JCBank Of Utah Trustee · Salt Lake City, UTN565JMNational Oceanic And Atomospheric Administration · Lakeland, FLN565JTBank Of Utah Trustee · Salt Lake City, UTN566PGC2d LLC · Wilmington, DEN568GAGulfstream Aerospace Corp · Savannah, GAN568JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN569DC56 Holdings LLC · Las Vegas, NVN56BUBsi Holdings LLC · Portland, ORN56CAusome Aviation LLC · Newark, DEN575BGWmb Global 2018 LLC · Opa Locka, FLN581DWilmington Trust Co Trustee · Wilmington, DEN582DWeidner Property Management LLC · Kirkland, WAN585DSt Con Aviation LLC · Nashville, TNN585DWColleen Corp · New Castle, DEN585JCTvpx Ars Inc Trustee · North Salt Lake, UTN586GDGulfstream Aerospace Corp · Savannah, GAN587GDGulfstream Aerospace Corp · Savannah, GAN5883Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN588CV9354 Leasing LLC · West Palm Beach, FL
Back to AD 2011-22-01