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.
N65CCNbi Holdings LLC · New Bremen, OHN65EQAstra Alpha 650 LLC · Newburgh, NYN65KLRegency Aviation LLC · Edgewater, MDN65NKKokoland LLC · Camden, DEN65TPAltex LLC · Lincolnwood, ILN65WLWillis Lease Finance Corp · Coconut Creek, FLN660FXFlexjet LLC · Cleveland, OHN660HH94924 LLC · Medford, ORN661FXCopperwood Asset Management Lp · Cleveland, OHN661HNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN662FXFlexjet LLC · Cleveland, OHN664FXPlm Services LLC · Cleveland, OHN665JJUmb Bank Na Trustee · Salt Lake City, UTN667BBCsc Delaware Trust Co Trustee · Wilmington, DEN667FXTexas All Seasons Heavy Equipment LLC · Cleveland, OHN667JDWch Aa Inc · White Plains, NYN668BBCsc Delaware Trust Co Trustee · Wilmington, DEN669FXFlexjet LLC · Cleveland, OHN669TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN66CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN66ZGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN670FXFlexjet LLC · Cleveland, OHN670RRTvpx Trust Co LLC · North Salt Lake, UTN671LEGreen Sky Aviation LLC · Jupiter, FLN672EVBombardier Aerospace Corp · Dallas, TXN672FXPrincess Peanut LLC · Cleveland, OHN673FXBuster Aviation Inc · Cleveland, OHN677FNational Science Foundation · Alexandria, VAN678FXFlexjet LLC · Cleveland, OHN68005Mmap LLC · Houston, TXN680FXFlexjet LLC · Cleveland, OHN684MTRegistered aircraftN68889Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN688CBFrc Holding Inc V · Dover, DEN689WMN2fd LLC · Miami Beach, FLN68CMPated LLC · Coral Gables, FLN68KPWilmington Trust Co Trustee · Wilmington, DEN692LN900e LLC · Jensen Beach, FLN699KRBank Of Utah Trustee · Salt Lake City, UTN69CKCd 321 LLC · Austin, TXN69JPPaul Air LLC · San Juan, PRN6FKAircraft T&F LLC Trustee · Wilmington, DEN6JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN700HAWilmington Trust Co Trustee · Wilmington, DEN700HMHarbert Global Aviation LLC · Birmingham, ALN700MKWilmington Trust Co Trustee · Wilmington, DEN700YBYb Global LLC · Mequon, WIN702ERRegistered aircraftN702LKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN702QVNaqvi Law LLC · Las Vegas, NV
Back to AD 2011-22-01