AD 2011-20-01
Registered aircraft · 677
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-20-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-20-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-20-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-20-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.
N294TXTransmedics Inc · Belgrade, MTN295TXTransmedics Inc · Belgrade, MTN297TXTransmedics Inc · Belgrade, MTN298TXTransmedics Inc · Belgrade, MTN299PPCastle Aviation II LLC · Meridian, MSN29GSAir Cashmere LLC · Granger, INN300DPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN300EEPhenom Flight Operations LLC · Marion, INN300EZAvex Xi LLC · Fort Lauderdale, FLN300FJRichbuilt Construction LLC · Fort Pierce, FLN300FLValiair Lc Trustee · Casper, WYN300FMTailwinds 300 LLC · Friendswood, TXN300FPCapital Holdings 232 LLC · La Porte, INN300GMRosedale Aircraft LLC · Cedar Rapids, IAN300GVWheels Up Partners LLC · New York, NYN300HJ300e LLC · Miami, FLN300HYLgp Holding LLC · Chicago, ILN300JKCerulean Advisory LLC · Houston, TXN300MGEon Management LLC · Miami, FLN300MWSolidfire Racing LLC · Kalispell, MTN300QSRegistered aircraftN300RXNorthside Hay Company Inc · Tempe, AZN300ZZExecutive Airshare LLC · Overland Park, KSN301AZPhenom 300 LLC · Fort Lauderdale, FLN301BERegistered aircraftN301FXPoirrier Sharon · Cleveland, OHN301XTTub Time Aviation LLC · Portland, ORN302AZPhenom 300 LLC · Fort Lauderdale, FLN302FXRpc Strategies LLC · Cleveland, OHN302QSRegistered aircraftN302TGCrg Investments LLC · Carmel, INN303FXRpc Strategies LLC · Cleveland, OHN303QSRegistered aircraftN303TGTvpx Ars Inc Trustee · North Salt Lake, UTN304FXFlexjet LLC · Cleveland, OHN304QSRegistered aircraftN305FXFlexjet LLC · Cleveland, OHN306FLRains Ronald D · Odessa, TXN306FXFlexjet LLC · Cleveland, OHN306QSNetjets Sales Inc · Columbus, OHN307FXKaribu Lepidoptera LLC · Cleveland, OHN308FXFlexjet LLC · Cleveland, OHN309FXFlexjet LLC · Cleveland, OHN309QSRegistered aircraftN310FXFlexjet LLC · Cleveland, OHN310QSRegistered aircraftN311FXFlexjet LLC · Cleveland, OHN311QSEmbraer Executive Aircraft Inc · Melbourne, FLN312FLBam Acquisitions LLC · Carmel, INN312FXFlexjet LLC · Cleveland, OH
Back to AD 2011-20-01