AD 2001-22-10
Registered aircraft · 474
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-22-10')
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-22-10')
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-22-10') 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-22-10') 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.
N310ZAZair Force One LLC · Mendenhall, MSN311BPWls Enterprise LLC · Portland, ORN311KBJet Plaid LLC · Nashville, TNN312SHRegistered aircraftN313JLJnl Equipment Leasing LLC · Camden, DEN313PJRpc Aviation LLC · Fayetteville, ARN313STIota Aviation LLC · Bloomfield Hills, MIN314SJHrm Aviation LLC · Chesterfield, MON315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN315SCInternational Skychase Corp · Alachua, FLN317MLMds Falcon LLC · Kittanning, PAN319CFOcean Drive Bulgaria Corp · Wilmington, DEN321AJM Hixson Aviation LLC · Denton, TXN321AKSnails Pace Aviation LLC · New York, NYN322FJRegistered aircraftN324SLAp Aviation LLC · Troy, VAN325EXFalcon 325 LLC · Fort Pierce, FLN328JLLamon Aviation LLC · Boise, IDN333DLD&S Aircraft LLC · Chicago, ILN345KMJdr Management LLC · Boca Raton, FLN346EXWebair LLC · Warrenton, VAN356LGRegistered aircraftN35KVMit Oregon LLC · Portland, ORN361DDWeco West LLC · Catarina, TXN361KBpcp Falcon N361k LLC · Wilmington, DEN3712CF900ex LLC · Minneapolis, MNN373RRM10 LLC · Rolling Meadows, ILN373RSKalamazoo Group II LLC · Kalamazoo, MIN37WXCsc Delaware Trust Co Trustee · Wilmington, DEN382KUMaverick Aire LLC · New Castle, CON383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN388BBPw Transport LLC · Lafayette, LAN38TVLs Mobile LLC · Weatherford, TXN395HEBillron LLC · Houston, TXN396JR396jr LLC · Macon, GAN39NPWilmington Trust Co Trustee · Wilmington, DEN400THDuke Vacation LLC · Wilmington, DEN401GJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN404FWcf Aircraft LLC · Detroit, MIN405EKArlington Aircraft Of Nevada LLC · Sun Lakes, AZN408CJDt Management Group LLC · Phoenix, AZN40LBFirst Premier Corp · Sioux Falls, SDN411CDRegistered aircraftN412ECBank Of Utah Trustee · Salt Lake City, UTN413VLFalcon Vl LLC · Wilmington, DEN416KCSpenaero Lc · Salt Lake City, UTN41MBRivers Equipment LLC · Nashville, TNN420PDKms Air LLC · West Bend, WIN424UAeronavis LLC · Wilmington, DE
Back to AD 2001-22-10