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.

N924AZN924az LLC · Miami, FLBuilt 2025 · S/N 172S13282N924CSobrado Victor M · Norman, OKBuilt 1992 · S/N 002N924CSBeinhauer Emerson R · Naperville, ILBuilt 1992 · S/N 1N924DLester Christopher J · Vancouver, WABuilt 1994 · S/N 001N924DBFlying Veterans Club Of San Francisco Inc · Belmont, CABuilt 1973 · S/N 28-7305198N924DMSmoketown Helicopters LLC · Smoketown, PABuilt 2002 · S/N 1253N924DWLive Free And Fly Hard LLC · Santa Cruz, CABuilt 1988 · S/N WOOD-0001N924EIzzard William S · Crescent City, FLBuilt 1996 · S/N 002N924JHSmith Nigel A · Winona, MNBuilt 2007 · S/N 3FX034N924JLGross John L · Carthage, MSBuilt 2015 · S/N 4580N924JPProck Jack A · Auburn, CABuilt 2014 · S/N 3RX128N924JWStephenson James M Jr · Hyampom, CABuilt 2000 · S/N 860-2000N924KAEvanoff Mark Alan · Saint Augustine, FLBuilt 1965 · S/N 28-21295N924LMAviation Industries LLC · Aurora, ILBuilt 2008 · S/N 4260N924LPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2002 · S/N 172S9204N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509N924NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881886N924PLWilliamson Jay S · Phoenix, AZBuilt 2017 · S/N 36-67/68-749N924SAGiber Sharon G · New Port Richey, FLBuilt 1978 · S/N 38-78A0178N924SHHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2005 · S/N 3871N924SJRickets And Associates LLC · Ardmore, OKBuilt 2019 · S/N 91838N924TEPlyler Robert S · Spring, TXBuilt 2002 · S/N 10203N92500Romeo Charlie Aviation LLC · Stuart, FLBuilt 1994 · S/N 2890207N92505Thunderbird Aviation Inc · Bloomington, MNBuilt 1994 · S/N 2890211N92508Pierce Stuart · Ridgefield, WABuilt 1946 · S/N 12-31N9250CRegion Flyers LLC · Valparaiso, INBuilt 1978 · S/N 28-7816451N9250DJouflas Nikos A · Anchorage, AKBuilt 1958 · S/N 18-6541N9250LBullitt Richard T · Humble, TXBuilt 1971 · S/N AA1A-0150N9250VFlight Trainer LLC · Wilmington, DEBuilt 2012 · S/N 172S11182N92511Mckay Donald A · Soldotna, AKS/N 12-34N92515Bowen Bruce C · Sturgis, SDBuilt 1946 · S/N 12-38N9251EArrowpoint Investments LLC · Mountain Brk, ALBuilt 1994 · S/N 3213084N9251JGholami Amir K · Santa Rosa, CABuilt 1966 · S/N 28-3326N9251MFelix Eric · Oshkosh, WIBuilt 1966 · S/N 3451N9251SAayan Air LLC · Westfield, MABuilt 1975 · S/N MC-387N9251WHering Lloyd L · Boulder, COBuilt 1967 · S/N 28-10922N92523Durner Charles L · Lewes, DEBuilt 1996 · S/N 22612N92525Sale Reported · Palmetto, FLSale reportedBuilt 2009 · S/N M-11-1095N9252HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17266047N9252JFlying Wrenches LLC · Cairo, NEBuilt 1966 · S/N 28-3327N9252MStarfox Aero LLC · Hays, KSBuilt 1966 · S/N 3452N9253Gorman John J III · Statesville, NCBuilt 1993 · S/N 592RN92536Ott Dean R · Carrollton, OHBuilt 1946 · S/N 12-60N92538Todd Terry A · Firth, IDBuilt 1946 · S/N 12-64N9253ABowman Gerald L · Santaquin, UTS/N 1N9253DHand Keith A · Anchorage, AKBuilt 1958 · S/N 18-6546N9253LMaj Holdings LLC · Norfolk, VABuilt 1971 · S/N AA1A-0153N9253MBlue Eagle Air LLC · Singer Island, FLBuilt 1985 · S/N 32R-8513010N9253RDr Equipment LLC · Ackerly, TXBuilt 1978 · S/N R18200674N9253SKnuth Charles Allen · Avon, INBuilt 1975 · S/N M-1750
Back to AD 81-18-04 R2