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.
N25172Career Track 5 LLC · Wilmington, DEN25173Career Track 3 LLC · Wilmington, DEN25176Career Track 3 LLC · Wilmington, DEN25177Career Track 5 LLC · Wilmington, DEN25179Strite Kenneth J · Xenia, OHN2517RWaterfront Developers Inc · Hickory, NCN25180Career Track 5 LLC · Wilmington, DEN25181Career Track 3 LLC · Wilmington, DEN25182Career Track 3 LLC · Wilmington, DEN25184Career Track 5 LLC · Wilmington, DEN25186Soule Raymond · Wiscasset, MEN25187Career Track 3 LLC · Wilmington, DEN25188Career Track 3 LLC · Wilmington, DEN25189Career Track 5 LLC · Wilmington, DEN2518ZAircraft & Aviation Professionals LLC · Coldwater, MIN25190Wiley Calvin B · Summer Shade, KYN25191Textron Aviation Inc · Wichita, KSN25194Career Track 3 LLC · Wilmington, DEN25199Career Track 5 LLC · Wilmington, DEN2519QWhite Shane A · Fayetteville, GAN2519TDouglas James E · Fallbrook, CAN2519WWilliam Rainey Harper College District 512 · Palatine, ILN251AGHays Cory W · Beaumont, TXFirst renewal noticeN251AUPeregrine Howard Partners II Lp · New Orleans, LAN251BDWheatly Andy · Hedley, TXN251CACivil Air Patrol · Maxwell Afb, ALN251DBSnoopys Air Service LLC · Wappingers Falls, NYN251DWWallin Aviation LLC · Taylorsville, UTN251DYYbarra Daniel T · Westcliffe, CON251EARegistered aircraftN251ECBoundless Action Sports LLC · Cameron Park, CAN251EPEpic Aviation Inc · New Smyrna Beach, FLN251GJendair LLC · New York, NYN251HFHaidar Aviation LLC · Dallas, TXN251HPKoch & Koch Inc · Grass Valley, CAN251MBGolden Eagle Aviators Inc · West Jordan, UTN251MECavu Aircraft Group LLC · Green Cove Springs, FLN251MGGeorgia Aviation Authority · Eastman, GAN251RGBunn Mary · Williamstown, WVN251SFCgc Prop Plane 1 LLC · Metairie, LAN251TCTexas State Technical College · Waco, TXN251TTTyson David · Lusk, WYN251WCThyssen Patrick L · Conroe, TXN251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN251WHTallmadge Brian · Prescott, AZN251WYNorton Robert · Coeur D Alene, IDN251YAnderson Michael A · Bowie, MDN25200Career Track 3 LLC · Wilmington, DEN25204Career Track 5 LLC · Wilmington, DEN25205Career Track 5 LLC · Wilmington, DE
Back to AD 2006-10-21