OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N1902HAbraxis Air LLC · Casa Grande, AZBuilt 1977 · S/N 28-7716060N1902YFlowers John H · Laurel, MSBuilt 1964 · S/N 287N1903HEsp Aviation LLC · Mason City, IABuilt 1977 · S/N 28-7790351N1903QMatter Gregory · Sherman, TXBuilt 1972 · S/N 177RG0303N1904HSpyropoulos Basil P · Lake Geneva, WIBuilt 1977 · S/N 28-7790352N1905VNew Horizons Aviation Inc · Goshen, INBuilt 1974 · S/N 17263788N1906AHoyer Larry B · Fort Peck, MTBuilt 1952 · S/N 18-1739N1906LMosher David A · Pacifica, CABuilt 2016 · S/N 1906N1906SMiskovic Dejan · San Jose, CABuilt 1999 · S/N 1906N1906VN46132 LLC · Kalispell, MTBuilt 1974 · S/N 17263789N1907AKnopke James M · Two Rivers, AKBuilt 1952 · S/N 18-1741N1907QSimmons Marilyn K · Wilmington, DEBuilt 1972 · S/N 177RG0307N1908FMccloskey Cynthia · Matthews, NCBuilt 1973 · S/N 17256493N19093Gedney Douglas Kevin · Issaquah, WAS/N 17702556N1909QHarper Donald W · Odenton, MDBuilt 1972 · S/N 177RG0309N1909SDennerline Rhett R · Northfield, ILBuilt 1999 · S/N 1909N1909UBranch Stephanie B · Papillion, NEBuilt 1974 · S/N 28-7425215N1909YDuncan Lori Ann · New Tazewell, TNBuilt 1964 · S/N 204N190AGCarson Ryan P · Albuquerque, NMBuilt 1990 · S/N 10000N190AMMoghaddas Ali · Lake Sherwood, CABuilt 2010 · S/N 001N190BWheaton Joshua L · Denver, COBuilt 1999 · S/N 760N190BTHitchcock Aviation LLC · Twin Falls, IDBuilt 1981 · S/N 18-8109058N190CBStarflyer Inc · Brunswick, OHBuilt 2010 · S/N 4470N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103N190GESale Reported · Minden, NVSale reportedS/N 81689N190GTRincon Gabriel · Baton Rouge, LABuilt 2001 · S/N 2023N190HMn Helicopters Inc · Minneapolis, MNBuilt 2007 · S/N 4215N190JTravel Services LLC · Metropolis, ILBuilt 2014 · S/N 1142-2014N190KASpencer William D · Martinsville, VAS/N 1N190KTChupp Aaron A · Gallipolis, OHBuilt 2003 · S/N F003N190LPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 2002 · S/N 172S9190N190MALightning Aviation LLC · Gillette, WYBuilt 2004 · S/N 40.355N190MEMenagerie Enterprises Inc DBA · Denison, TXBuilt 2012 · S/N 172S11190N190MNKraemer Jeremy A · Melrose, MNBuilt 2024 · S/N JA2201190N190RROrr John C · Longmont, COBuilt 1997 · S/N 23039N190RVMccormick David E · Antioch, ILBuilt 1998 · S/N 30424N190SEAlbritton Randy L · Camas, WABuilt 2021 · S/N 101N190YSalo Mark W · Poulsbo, WABuilt 2005 · S/N 23085CN19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557N1910PWesley Gary J · Moorland, IABuilt 1955 · S/N 22-2657N1910TBrown James E · Wind Lake, WIBuilt 1971 · S/N 28-7125464N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559N1911ADay Patrick J · Bloomer, WIBuilt 1952 · S/N 18-1745N1911HAdair Aviation LLC · Mountain Home, ARBuilt 1980 · S/N R18201550N1911PWalker Raymond Lee · Saint Charles, MIBuilt 1955 · S/N 22-2590N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103N1911Y1911y Aviation LLC · Windsor, ILBuilt 2025 · S/N 42336N1912AWebber David A · Delta Junction, AKBuilt 1952 · S/N 18-1748
Back to AD 81-18-04 R2