AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2360ARegistration Pending · Cedar Falls, IARegistration pendingN2360QStar Ads Incorporated · Torrance, CAN2360RLamarra Anthony A · Clarkston, MIN2360YEggemeyer Bradford J · Groom, TXN2361BCaudell Michael A · Cleveland, GAN2361RVenture West LLC · Mesa, AZN2362CCelek Brian F · Charleston, SCN2362JBauer Bryce · Forestville, CAN2363KJerk Assets LLC · Bakersfield, CAN2363S182 Skylane LLC · Loxahatchee, FLN2363USyracuse Flying Club Inc · Fayetteville, NYN23653Gales Charles R · Cleverdale, NYN23655Redline Aviation LLC · Wilmington, DEN2365CStrolin LLC · Maple Valley, WAN2365FBottorff Jon C · Fishers, INN2365JBrosius Michael W · North Platte, NEN2365NDulles Aviation · Bristow, VAN23660Amblin Antique Air Inc · Green Cove Springs, FLN2366GDelaware Aircraft Trust LLC Trustee · New Castle, DEN2366MWestbank Fishing LLC · Kiln, MSN2366NKohnen Patrick Kennedy · Flagstaff, AZN2366YAvco Patrol LLC · Lyndon, KSN23675Atlanta Aviation Academy Inc · Lawrenceville, GAN23676A&E Flying Club Of Los Angeles Inc · Hawthorne, CAN23677Doering Jim · Arcadia, CAN23678Warner Donald R · Milford, MIN2367MPeterson Aviation LLC · Oregon, WIN2367X182 Jkp LLC · Fall River, MAN2367ZBrookie Aircraft LLC · Methuen, MAN2368GRegistered aircraftN2368PAerial Messages Leasing Co · Longwood, FLN2368SShane LLC · Wilmington, DEN2369KMgm Aviation LLC · Montara, CAN2369WRoyal Kenneth L · Savannah, GAN2369XChristiansen Aviation LLC · Wilmington, DEN2369ZDhs Operations LLC · Wilmington, DEN236ABOdonnell William J · Hampton, NHN236AGTroposphere Ventures LLC · Fond Du Lac, WIN236BHEagle Aero L L P · Carlsbad, NMN236BLPiper Aircraft Inc · Vero Beach, FLN236CDLoven Richard · Waukon, IAN236CMWright Kim B · Anchorage, AKN236DProfessional Training Aircraft LLC · Wilmington, DEN236JTempleton James N · Petersburg, ILN236JAT & S Gentile Inc · Wintersville, OHN236JNDickerson Bradley D · Jasonville, INN236MABountiful Flight LLC · Woods Cross, UTN236MGGeorgia Aviation Authority · Eastman, GAN236MHMillion Air Aviation LLC · Queen Creek, AZN236MKAllford John · Mcalester, OK
Back to AD 2006-10-21