AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N806TDWall Joseph J · Chamberlain, SDN80700Changes In Latitude LLC · Kingwood, TXN80703Trager Kenneth C · Prague, OKN8070CKnutson Wayne R · Tioga, NDN8070UMartin Jack W Jr · Dublin, GAN8070WMordini Robert D · Grand Marais, MNFirst renewal noticeN8071GBell John · Queen Creek, AZN8071LRogers Jonathan T · College Place, WAN8071NFigone David Anthony · Williams, AZN8071SNolan Cynthia M · Rimrock, AZN8071WFernandez Gregory · San Antonio, TXN8071XFlorida Aviation Career Training Inc · Saint Augustine, FLN8071YFrost Aviation Services Inc · Las Cruces, NMN8071ZScanlon Daniel T Jr · East Greenwich, RIN80725High Flight Academy LLC · Allison Park, PAN80729Poon Tsui P · Rosemead, CAN8072POn Three Angels Wings LLC · Melbourne, FLN8072XHillsboro Aero Academy LLC · Hillsboro, ORN80730Davis Lee B · North Little Rock, ARN80731Herman Robert W · Vineyard Haven, MAN80734Tipps Robert J Jr · Port Aransas, TXN80735S & S Aircraft Inc · El Dorado, ARN80738Woods Duane · Enid, OKN8073DPetersen Mark A · Willow, AKN8073EOcean Aviation Inc · Berlin, MDN8073GBaker Brenten E · Farmington Hills, MIN8073NKiwi Choppers LLC · Hillsboro, ORN8074Turner Bryan J · Occidental, CAN80742Elliott Richard D · Castle Rock, WAN8074DVan Hatten Michael Sr · Fairbanks, AKN8074GBudge Ross Spencer · Colorado Springs, CON8074TWilliams Evan H · Sebastopol, CAN8074YWhistle Air LLC · Seymour, INN80751Haaland Karlyle R · Dalhart, TXN80756Badeaux William C Jr · La Porte, TXN80759Leaseair LLC · Wilmington, DEN8075CGuest Stephen J · El Cajon, CAN8075EBlue Sky Flying Club LLC · Granger, IAN8075PAir Ads Inc · El Cajon, CAN8075WPale Horse Imports Inc · Shingletown, CAN8075XBruce Jerry W II · Starkville, MSN8075YAirplanes Of Kankakee · Kankakee, ILN80762Moving Tails Aviation LLC · Woodbridge, VAN80764Mcneill Jim R · Wichita, KSN80765Taylor Kyle T · Texas City, TXN80767Ainsworth Martha Trustee · Bowie, MDN80769Tucker Robert O · Savannah, GAN8076CStuart Chris W · Fairbanks, AKN8076GGriffin Billy J · Corona, CAN8076WTipton James · Hot Springs, AR
Back to AD 90-04-06 R1