AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N87093Wheeler Russell E · Roxbury, CTN8709BBaldwin Steve · Lawson, MON8709UWilkinson James Richard · Carlsbad, NMN870SARowland Glen J · Monrovia, INN8710Volkmann James · Bellingham, WAN87100Mcnew Stephen J · Brookville, OHN87101Courser Jacob A · West Hartford, CTN8710SKressin Ray H · Waunakee, WIN8710UDmac Aircraft LLC · Savannah, GAN87112Morrilton Flying Club Inc · Conway, ARN87118Wittco Aero LLC · Vancouver, WAN8711BHubert Gregory D · Charles Town, WVN8711GBonno Douglas L · Iron River, MIN87121Clark Charles A · Fitzgerald, GAN87124Kadel James R · Portsmouth, OHN8712SMarys Airport Acres LLC · Neenah, WIN8715BSchultz John J · Kenai, AKN8715SAllen Thomas Page · Comer, GAN87161Carlberg Brad S · Hoodsport, WAN8716SBores Scott J · Huron, OHN8716UWings Of Hope · Chesterfield, MON87171Toth Richard J · Windber, PAN8717BNorsic Michael · Parma, OHN87187Fountain Robert A · Suitland, MDN8718UPuckett Matthew Scott · Argyle, TXN8719BSale Reported · Westerville, NESale reported, canceledN8719GRosso Anthony J · Wallace, NCN87207Crofut Reha A · Westville, OKN87215Orr Leroy A · Tonasket, WAN8721SPruden Larry J · Louise, MSN8722BBuell Jack A · St Maries, IDN8723GEastham Gregory L · Columbia, KYN8723SCondor Aviation LLC · South Saint Paul, MNN8723UTraining Services Inc T/A · Virginia Beach, VAN87240Hacker James D · Borden, INN87248Biggs William E · Temple, TXN8724BMcmahon William · Westville, INN8724URonald O Holcomb LLC · Lapeer, MIN8725SKolis Joseph E II · Springfield, ILN8725UArklamiss Aviation LLC · Ruston, LAN8726BEckles Phillip · Holdenville, OKN8726GJacks Benjamin Scott · Chanute, KSN8726UHowell Harley L · Colville, WAN87274Webb Aaron J · Monroe, GAN87277Webb Patrick S · Chuckey, TNN8727SMejia Jose Patricio · Meridian, IDN87283Hornby Larry E · Helena, MTN8729BChristian Melvin Lee Jr · Apison, TNN8729UEpmeier Bruce E · Newburgh, INN872DPennington Carl B Jr · Elm City, NC
Back to AD 94-05-05 R1