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.
N158RVVans Aircraft Inc · Aurora, ORN158SFAlba Leasing Services LLC · Scottsdale, AZN158SHSpitzer Helicopter LLC · Woodland Hills, CAN158SQGriffith Aviation Inc · Griffith, INN158TZBoney George C Jr Trustee · Chapin, SCN158WUYale Companies LLC DBA · Indianapolis, INN15901Harbor Aviation LLC · Wilmington, DEN15909Downes Pamela M · Chino Hills, CAN1590WCc Aviation Inc · Tracy, CAN1590XLanders Stephen F · Riverview, FLN15918Ramseier Peter A · Imperial Beach, CAN15919Tikhomirov Anton · Ashland, MAN1591XTask Aviation LLC · Vancouver, WAN15925Everglades Aviation Academy LLC · Weston, FLN15928Bussell Matthew W · Reno, NVN15929Cs Flying Ltd · Grafton, OHN1592RWilliams Brian S · Marietta, GAN15930Rogers Aviation LLC · Florence, SCN15931Smitty 172 LLC · Rockford, MIN15935Stahl Dennis E · Wood Dale, ILN15936Brown Norman C · Kewanee, ILN15939Ray H Gregg · Nashville, GAN1593XVaniscak Greg A · Fort Collins, CON15944Habit Samuel P · Kokomo, INN15945Newton Flying Club Inc · Collinsville, MSN15946Leading Edge Inc · Cottonwood Heights, UTN1594XPiper Flyers LLC · Zionsville, INN15956Hanson Mark E · Griffin, GAN15957Jones John E Jr · Metter, GAN1595RImpulsion Unlimited Inc · Huddleston, VAN15961Kings Wings · Jupiter, FLN15968Culberson Donald J · Orange Park, FLN1596ETeam 172-03 LLC · Warsaw, INN1596RTc Aviation Ltd · Fairbanks, AKN15975Bourgeois David · Westminster, MAN15976Lake Life Aviation LLC · Yukon, OKN15979Tron Aviation LLC · Newburgh, INN1597BRehman Furqan · Germantown, MDN1598BTimerider Technologies Inc · Bishop, CAN1598RJam Cat LLC · Orlando, FLN15997Stockman Greg · Allenton, MIN15999Emmert Jason L · Douglas, WYN1599RLuka Robert E · Berea, KYN1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIN159ARRobertson Duncan · ForfarNon-citizen corporation, flight hours not reportedN159BOppold Robert S · Overland Park, KSN159DMLe Kenneth · Henderson, NVN159DRPiedmont Flight Inc · Winston Salem, NCN159DSSmart Charles R · Verden, OKN159FSEastern Kentrucky University · Richmond, KY
Back to AD 2006-10-21