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.
N999HEPinnacle Aviation Services Inc · Encinitas, CAN999HKGeboy Alan R II · Newnan, GAN999HPChisholm Hugh S Jr · Thomson, GAN999HRPage Edward C · Thornhurst, PAN999HSBurton John R · Punta Gorda, FLN999JKlenoski Brian D · Fulton, MIN999JFPrt LLC · Pottsboro, TXN999JMCrosby Lee R · Hyrum, UTN999JVWatson James W · Fairbanks, AKN999KKStavang Herman Wayne Trustee · Snelling, CAN999KWTeodoro Scott · Fox Island, WAN999LAAero Equities LLC · Ventura, CAN999LHRossi Christopher G · Paso Robles, CAN999MLesterville Land Holdings LLC · Ellington, MON999MAMccreery Aviation Co Inc · Mcallen, TXN999MJKoelbl Aviation LLC · Whitesboro, TXN999MPLeblanc Vial Joseph III · Loranger, LAN999MROrth Jacob N · San Antonio, TXN999MWStevens David L · Golden, CON999NFCoast Flight Training And Management Inc · San Diego, CAN999NTHolbrook Joel · Delta Junction, AKN999NWBoss Gary W · Bronston, KYN999PAGoodwin William S · Sequim, WAN999PEMiller Byron W · Silverton, ORN999QAQuebec Alpha LLC · Milwaukie, ORN999RATimkin Inc · Wilmington, DEN999RJReschke William E · San Diego, CAN999RMMorgan Ryan · New Port Richey, FLN999SNBauer Michael J · Kenai, AKN999SPMcgilvray Andrea · Bandera, TXN999SRRaybob Ltd · Demarest, NJN999STMapes Neal E · Prineville, ORN999TDBarber Richard T · Canton, OHN999TMAsplundh Eric P · Bryn Athyn, PAN999TTKnueven Timothy P · Brownsboro, ALN999TWThomas Aviation LLC · Orleans, CAN999TXDel Mar College · Corpus Christi, TXN999VCDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN999VFCrawford David B · Warren, OHN999VHMike Charlie Inc · Lewes, DEN999VLHeidt Brian F · Owosso, MIN999VVGregory A Pfeil · West Jefferson, OHN999WBEastern Kentucky University · Richmond, KYN999WGGreenwald Willard F · North Adams, MAN999WNBurgess Ross W Trustee · Bedford, TXN999WWRaymer Michael K · Alma, ARN999XSStoffel Richard T · Sequim, WAN999YDTru North LLC · Sterling, AKN99ARTiffin Aire Inc · Tiffin, OHN99BAInternational Air Services Inc Trustee · Carson City, NV
Back to AD 81-18-04 R2