OpenAirDocs.org
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.

N3773NSkytypers Inc DBA · Las Vegas, NVBuilt 1979 · S/N AA5B-1229N3773TVos Real Estate LLC · Holland, MIBuilt 1967 · S/N 28R-30085N3773XFerris David L · Kerrville, TXS/N 266N3773YSirius Aeronautics LLC · Buda, TXS/N AA5B-1273N3774AMasephol James A · Phillips, WIBuilt 1954 · S/N 22-2016N3774HRegistered aircraftBuilt 1979 · S/N 24-0938N3774ZOwen Matthew L · Kasilof, AKS/N 18-7454N37750Bacon Gregory · Prairie Home, MOBuilt 1968 · S/N 680883(6716776)N3775BMummy Mountain Med LLC · Paradise Valley, AZBuilt 1955 · S/N CH-187N3775FHickle William H · Inyokern, CABuilt 1977 · S/N 0766N3775NMedic Choppers LLC · Springdale, ARS/N WW1N3775PClayton Patrick D · Hazen, ARBuilt 1955 · S/N 18-4663N3775RBack Mark D · Washington, DCBuilt 1970 · S/N 28-5818N3776XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1968 · S/N 270N3777LCowboy Aviation Services LLC · Polson, MTBuilt 2001 · S/N 3RX013N3777PSkatvold Charles P · Moorhead, MNBuilt 1959 · S/N 18-4665N3777TStewart Donald J · Palm City, FLBuilt 1967 · S/N 28R-30089N3777ZAnderson Clarence Trustee · Anchorage, AKS/N 18-7459N3778TVan De Vanter Robert A · Paso Robles, CAS/N 28R-30090N3778XChang Tim C · Ocala, FLFirst renewal noticeBuilt 1968 · S/N 271N3778ZWard Nelson H · Salcha, AKBuilt 1960 · S/N 18-7460N37790Cottrell Mark C · Leitchfield, KYBuilt 1982 · S/N RHM-1N3779AForte Angelo L · Franklinville, NJBuilt 1953 · S/N 22-2021N3779NObrien Edward Trustee · Walnut Creek, CAS/N 680116N3779TShultz Martin · Naperville, ILBuilt 1967 · S/N 28R-30091N3779WAirmotive Service LLC · Brigham City, UTBuilt 1966 · S/N 32-701N3779ZNace Kris A · Glendale, ORBuilt 1960 · S/N 18-7461N377BFountain Acquisitions LLC · Mount Vernon, GAS/N TD-69N377BAHolliday Richard A · Fort Worth, TXBuilt 1977 · S/N 177RG1245N377BMQuebec Helicopter LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1691MN377CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283308N377CBBradley Charles A · Gibsonia, PAS/N 24980N377CPHodgson Jeffrey R · Watsonville, CAFirst renewal noticeBuilt 2010 · S/N 70377N377CZKramer Dean E · Bernville, PABuilt 1960 · S/N 18-7448N377DSSeward Bernard L Jr · Charlottesville, VABuilt 2003 · S/N 40.277N377EBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608182N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086N377HGHunt James J · Dalton, PABuilt 1998 · S/N 1252-98N377HHJennings Christopher Wyckoff Trustee · Brentwood, TNBuilt 1970 · S/N 39-13N377HLLatshaw Hunter W · Mount Holly, NCBuilt 2007 · S/N 71854N377JDStyer David · Milton Freewater, ORS/N 2007N377KGGardetto Paul R · Oconomowoc, WIBuilt 2014 · S/N 73266N377LDJohnson Harvey P · Roseau, MNBuilt 2008 · S/N 72140N377LLLawson Larry · Palmer, AKBuilt 2009 · S/N CC18-0040N377LMOliver Gerald D III · Midlothian, TXBuilt 2008 · S/N 648N377RCAncona Air LLC · Wixom, MIBuilt 1978 · S/N 61P05757963251N377SXColberg Chad W · Port Orange, FLBuilt 1991 · S/N 77N377THMenard Keith L · Bellevue, TXS/N 3284N37809Cavanagh Michael B · Dubois, WYBuilt 1983 · S/N 004N3780MRegistration Pending · Cody, WYRegistration pendingBuilt 1947 · S/N 12-2710
Back to AD 81-18-04 R2