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.

N56141Simmerer Stephen J · Allenton, MIBuilt 1973 · S/N 28R-7335364N56149Lets Fly LLC · Albemarle, NCBuilt 1973 · S/N 28-7325579N5614LFiler Jacob Adam · Clarksville, TNBuilt 1968 · S/N AA1-0016N5614PShetty Balakrishna · Wesley Chapel, FLBuilt 1959 · S/N 24-682N5614QAltitude Aviation Services LLC · Mountain Home, IDS/N 663N5614WColeman John H · Jackson, MIBuilt 1962 · S/N 28-754N56155Blackmon Ethan T · Hot Springs, ARS/N 32-7300053N56158Munyon William · Vineland, NJBuilt 1973 · S/N 28-7325583N5615LAnthonson Ronald G · Cortland, NYBuilt 1968 · S/N AA1-0017N5615QKhan Awad A · Clearwater, FLBuilt 1965 · S/N 3103N5615WH&H Aviation LLC · Lehi, UTBuilt 1963 · S/N 28-755N5615ZKuebler Terry T · Gahanna, OHBuilt 1962 · S/N 22-9427N56160Thatcher Michael · Delaware, OHBuilt 1973 · S/N 28-7305543N56161Ohmart Jeffrey A · Wichita, KSBuilt 1973 · S/N 28-7305544N5616EDhl Skyhawk Inc · Martinez, CABuilt 1978 · S/N 17271902N5616PKallenberger Ross A · Bakersfield, CABuilt 1959 · S/N 24-684N5616YBigfoot Aviation LLC · Wilmington, DEBuilt 1965 · S/N 18-8287N5617Roberts Andrew J · Brunswick, MEBuilt 2007 · S/N 7090N5617JSale Reported · Wilton, CASale reportedBuilt 1980 · S/N 17273822N5617PBuchheit Dirk · Lake Worth, FLBuilt 1959 · S/N 24-685N5617QRegistration Pending · Perryton, TXRegistration pendingBuilt 1965 · S/N 3007N5617UManagement Company Of South Carolina LLC · West Columbia, SCBuilt 1969 · S/N 28-26406N5617WRose Dean R · Appleton, WIBuilt 1962 · S/N 28-758N56182Gerst Peter C · Williamsport, PABuilt 1973 · S/N 28-7325586N5618QHecker Clark R · Flat Rock, NCBuilt 1965 · S/N 665N5618ZNull Clifford M · Punxsutawney, PABuilt 1962 · S/N 22-9430N56190Bertch Gary M · Waterloo, IABuilt 1973 · S/N 28-7305550N56191Twedt Jeffrey Lee · Montrose, SDS/N 28R-7335379N56198Holden James R Jr · Milton, GABuilt 1973 · S/N 28-7325588N5619ELiberty Flying Service LLC · Castroville, TXBuilt 1978 · S/N 17271903N5619HFranklin Vernon L · Aguila, AZBuilt 1949 · S/N 16-230N5619LEncarnacion Ramon A · Miramar, FLS/N AA1-0021N5619WIsbell David Myles · Tucson, AZBuilt 1962 · S/N 28-761N561BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010040N561DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12066N561DEFlynn John M · Martinez, CABuilt 1975 · S/N 17265572N561FGRidgeline Assets LLC · Wilmington, DEBuilt 2022 · S/N 172S12909N561FLOnwe Edward E · San Antonio, TXBuilt 1971 · S/N 28-7125402N561FSGummo Thomas L · Apple Valley, CABuilt 2001 · S/N 2250N561MAMcdonald Jeffrey D · Chilmark, MABuilt 2003 · S/N 2843561N561MBVital Equipment LLC · Midland, TXBuilt 2004 · S/N 18281425N561MHDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 28-7690264N561NDSpartan Education LLC · Tulsa, OKBuilt 2011 · S/N 172S11099N561PWestern Farming LLC · Missoula, MTBuilt 2006 · S/N 485-2006N561PKKlopchic Peter G · Seattle, WABuilt 1973 · S/N 32-7340124N561PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842103N561SAWingsleasing LLC · Wichita, KSBuilt 2004 · S/N 172S9638N561SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881399N561SDAugspurger David R · Seneca, SCBuilt 1979 · S/N 564-79N561SPIllinois State Police · Springfield, ILBuilt 2000 · S/N 18280825
Back to AD 81-18-04 R2