AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N8071YFrost 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, FLN8072TLane Aviation LLC · Tijeras, NMN8072XHillsboro Aero Academy LLC · Hillsboro, ORN8072YStoraker Kjetil · Mckinney, TXN80730Davis 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, IAN8075JClark Nikita C · Ontario, ORN8075PAir 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, CAN8076PBrownie Dale R · Stetson, MEN8076WTipton James · Hot Springs, ARN80772Payne Michael S · Sequim, WAN80773Boyl Traci L · Ukiah, CAN80774Dugger Aviation LLC · Merritt Island, FLN80775Sierra Bravo LLC · Littleton, CON80779Stein William R · Aptos, CAN8077CDavis Kern M · Saint Petersburg, FLN8077ESws Aviation Services Inc · Titusville, FLN8077GPhillips Stuart · La Conner, WA
Back to AD 81-18-04 R2