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.
N716MTColvin Mariann · Round Rock, TXN716NDUniversity Of North Dakota · Grand Forks, NDN716PCPcfo Air LLC · Plymouth, MNN716RGGarrett Robert S · Dallas, TXN716RHPowers Alan J · Fayetteville, GAN716RLPerguson Robert Cole · Converse, TXFirst renewal noticeN716RSSprouse Ronald E · Port Orchard, WAN716SCJuliet Charlie Aviation LLC · Oregon City, ORN716SPExec 1 Aviation II LLC · Ankeny, IAN716THFairmont State University · Fairmont, WVN7170GSs Skyways LLC · Becker, MNN7170PDalton Dennis P · Walsenburg, CON7170RBrown Joshua A · Fayetteville, GAN7170UWorley Ronald W · West Jefferson, NCN7170VKrack John L Trustee · Fridley, MNN7170WMontana Thomas · Port St Lucie, FLN7171FFriedrich Richard L · Georgetown, TXFirst renewal noticeN7171QMcnamara Bradley W · Seattle, WAN7171RYoungblood Steven H · Gilmer, TXN7171YHeinrich Steven W · Conroe, TXN71728Guskea Andrew E · Jericho, VTN7172KMeader Derek S · Marfa, TXN7172PBarksdale Kevin L · Moore, OKN7172QRounds Agronomy LLC · Pierre, SDN7172UMark21-Charlie LLC · Brownsburg, INN7172VGanji Borna · West Windsor, NJN7172WSkrypai Vladislav · Poplar Grove, ILN7173BEavenson Daniel Scott · Ripon, CAN7173GSale Reported · Haiku, HISale reportedN7173QWesterly Av Group LLC · Westerly, RIN7173RRushton George E · Clinton, MIN7173WCastro Joaquin H · Wellington, FLN7173ZAir Kraft Spraying Inc · Timber Lake, SDN7174BMercil Richard · Grand Forks, NDN7174GMaloney John T · Deer Park, NYN7174KBracarelli Lisa A · Big Lake, AKN7174UVondross James B · Portland, ORN7174VEast Carolina Aviation LLC · Camden, NCN7175GMontgomery Monty · Cave Spring, GAN7175KTaildragger Aero LLC · Saint John, WAN7175LDelong Aviation Services LLC · Murray, UTN7175PNewton Roger N Jr · Marerro, LAN7175RElks Virginia L · Chocowinity, NCN7175UWagner Mark · Grass Valley, CAN7176ASwierk Joshua J · Valdez, AKN7176BRegistered aircraftN7176QJax Beach Aviation LLC · Jacksonville, FLN7176VZammit Joseph A · Riverside, CAN7177DMurphy Brandon M · Edinburg, PAN7177GCoats George A · The Woodlands, TX
Back to AD 81-18-04 R2