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.
N588DCDynoair LLC · Watertown, SDN588DSCox Joshua · Ormond Beach, FLN588LAPiper 3 LLC · Chestnut Ridge, NYN588LESmith Jason E · Calliham, TXN588NDChristiansen Aviation LLC · Wilmington, DEN588RVBird Aloft LLC · Sheridan, WYN588SFIntrepid Helicopters LLC · Sylvania, OHN588TEJefferts Steven R · Longmont, CON5890DCouey Robert H · Anchorage, AKN5890LSturgeon Kenneth V · Winter Garden, FLN5890NSmith William Leonard · College Station, TXN5890PDaniels David R · Anthony, NMN5890QDevils Lake Aero Repair Inc · Devils Lake, NDN5890UKempton Lana Julia Trustee · Douglasville, GAN5890VEller Patricia E · Lutz, FLN5891DRiggs J'Ann · Wasilla, AKN5891HFelske Michael J · East Troy, WIN5891LAlldridge Thomas H · Cochranville, PAN5891RTun Bay Inc · Wasilla, AKN5891U2dwh LLC · Katy, TXN5891WMarino Mario Mennona · King Of Prussia, PAN58923Singh Jaspal · Sacramento, CAN5892UFeighl Engineering Group Inc · Hot Springs, ARN5892ZCarbiener Ross · Kewanee, ILN5893HAmos Derek L · Helena, MTN5893LHegwood Jonathan E · Petal, MSN5893NKoehn Juergen A · Lago Vista, TXN5893UCasper Gary · Spring Creek, NVN5893WFinch Howell M Jr · Victoria, TXN5893ZKugmach LLC · Holdrege, NEN5894LTrueblood Terry L · Effingham, ILN5894QBlech Fritz · Grants Pass, ORN5894ZRussell Webster K · Ridgeland, MSN5895HThompson Timothy G · Kenosha, WIN5895LWatkins Marion D · Mcdonough, GAN5895NCommander Club LLC · Hudson, WIN5895ZMerrick Richard W · Bernville, PAN5896PBurwell Brent C · New Ulm, TXN5896UGift Academy Inc · Vernon, TXN5897LCulver Christopher J · Rockmart, GAN5897QBarsi Jeffrey D · Bonham, TXN5898LLamer Benjamin W · Ada, MIN5898QO'Neal Timothy L · Damascus, ORN5898VMaxair Inc · Coxs Creek, KYN5898WFrazier Justyn K · Mesa, AZN589APa28 Aircraft LLC · Wilmington, DEN589CBBryan Curtis · Enumclaw, WAN589LAPiper 3 LLC · Chestnut Ridge, NYN589NDUniversity Of North Dakota John D Odegard School · Grand Forks, NDN589RAMcgowin James E · Ball Ground, GA
Back to AD 81-18-04 R2