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.
N948RRed Baron LLC · Middletown, DEN948RVGeer Roy R · Fort Worth, TXN948SAPavlatos Plato Nicholas · Springfield, OHN948SMScenic Concepts LLC · La Crosse, WIN948TPray Aviation Inc · Augusta, KSFirst renewal noticeN948WDAndrews Aviation Two LLC · Temple, TXN94901Liberty University · Lynchburg, VAN9490HNovak Rickson J · Pine City, MNN9490PSurti Freddy Rusi · Des Moines, WAN9491JRoy Thomas M Jr · Carbondale, ILN9491LVictoria Angel Guaroa · Lewisville, TXN9491NWalker Mark L · Turlock, CAN9492FDeer Creek Helicopters LLC · Chico, CAN9492HSchodack Aviation Association · Ghent, NYN9492NKnaust Kurt · Baldwinsville, NYN9492VRivera Jaime · San Antonio, TXN9492WHixson Robert S · Los Alamos, NMN9493DJack Browns Seaplane Base Inc · Winter Haven, FLN9493JHayes Enterprises · Glendale, AZN9493NHigh Prairie Aviation LLC · Washington, IAN9494DReder Monte D · Miles City, MTN9494GKelly William W · Springfield, ORN9494JRuiz Serge · Montgomery, TXN9494WDavisson Michael A · Edgewood, NMN94959Lane Community College · Eugene, ORN9495DEichholz Kenneth D · Cordova, TNN9495HNelson Flying Service LLC · Lansford, NDN9495NNagel Richard A · Mequon, WIN9495VSoccer Goals LLC · Christoval, TXN94963Twin Cities Air Service LLC · Gray, MEN9496DCavu Clearing LLC · Center Harbor, NHN9496VEvans Richard I · Elko, NVN9496WJones Terry · Bells, TNN9497JShushnar Gary J · Irvine, CAN9498JBrantley Hugh L · Hazlehurst, GAN9498KDirksen Caleb A · Garner, IAN9498LRaber Jonathan L · Baltimore, MDN9498NKoehler Scott A · Brighton, ILN9498VMoonshiner Aviation LLC · Austin, TXN94992Mac Air Corp · Benton, KSN9499BWyatt Bradley S · Bishop, CAN9499LRobinson Jason C · Fort Worth, TXN9499NFlight Niner Niner LLC · Charleston, SCN9499VBerliner Donald D · Medford, NJN9499ZDark Sky Enterprises LLC · Flagstaff, AZN949BMGoebel Michael M · Conroe, TXN949BVStout Billy V · Hooker, OKN949CDDupont Samuel F C · Mount Solon, VAN949CPCivil Air Patrol · Maxwell Afb, ALN949FSDraper Floyd L · El Paso, TX
Back to AD 81-18-04 R2