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.

N1613RGregg Jeffrey B · Sun Valley, CABuilt 1974 · S/N AA5-0713N1613VMcewen Michael A M D · Gadsden, ALBuilt 1974 · S/N 17263692N1613WArnold Stephen Paul · Falls Church, VABuilt 1972 · S/N AA5-0073N1614GGriffin Donald A · Alma, ILBuilt 1968 · S/N 607N1614JCoraggio Joseph · Chandler, AZBuilt 2015 · S/N 03N1615AAnson Air LLC · Sugar Land, TXBuilt 2005 · S/N 172S9910N1615EFisher Ralph B · Lutz, FLBuilt 1978 · S/N 17271067N1615VFrance Jeffrey A · Reedville, VABuilt 1974 · S/N 17263693N1616GGorton Trice J · Anchorage, AKBuilt 1968 · S/N 620N1616HMayworm Jeffrey A · Ocala, FLBuilt 1975 · S/N 177RG0789N1616POwen David C · Fort Myers, FLBuilt 1954 · S/N 22-2430N1616RBerck Michael P · Clackamas, ORBuilt 1974 · S/N AA5-0716N1617GDuch Jose M · Miami, FLBuilt 1968 · S/N 621N1617HFlying Cloud Cherokees Inc · Chanhassen, MNBuilt 1975 · S/N 177RG0790N1617VCook Timothy D · Ashville, NYBuilt 1974 · S/N 17263694N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491N1618CGerow Dennis L · Austin, TXBuilt 2016 · S/N 364N1618GBlue Moon Flying Club LLC · Westminster, MDBuilt 1968 · S/N 622N1618HMemrick Paul · Cedar Park, TXBuilt 1975 · S/N 177RG0791N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493N1619RNorman Richard L · Dallas, GABuilt 1975 · S/N AA1B-0519N161AMDe Boissard Karen · New York, NYS/N 2161N161AWAir Ward Inc · Columbia, CABuilt 1979 · S/N 28-8016078N161BGWilson James R · Midlothian, VABuilt 1978 · S/N 287816527N161BTCoffin Craig T · Glendale, CAS/N 161N161BWWelch William Ben · Danville, ILBuilt 2005 · S/N 10601N161CMR&J Helicopters LLC · Port Byron, ILBuilt 2016 · S/N 2444N161DFulper Lester D · Clearwater, FLBuilt 2024 · S/N 5745N161DERegistered aircraftBuilt 1977 · S/N 28-7816295N161DSHeffron Neuhold Nicholas A · Honolulu, HIBuilt 1977 · S/N 2136N161GBEagle Aviation LLC · Anchorage, AKBuilt 2015 · S/N MBL-002N161GLEdwards Jeffrey L · Port Orange, FLBuilt 1978 · S/N 0814N161GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1986 · S/N 17276650N161JLLuebben John R · Fayetteville, GABuilt 1966 · S/N 346N161KMParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716136N161LMays Stephen W · Carson City, NVBuilt 1971 · S/N 470N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163N161MSBaker Weldon J · Lamesa, TXBuilt 2002 · S/N 60469N161PRegistered aircraftBuilt 1958 · S/N 24-533N161PCSpence Jeffrey · Haskell, OKBuilt 2020 · S/N 40052N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156N161RBJones Anthony M · Oak Point, TXBuilt 1961 · S/N RB2N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952N161RKBreezy Flyers Aero Club · Kingston, TNBuilt 2000 · S/N 61877N161RLStovall Francis · Melbourne Beach, FLBuilt 2006 · S/N 80480N161RPCrucial LLC · Kalispell, MTBuilt 1982 · S/N 32R-8213049N161RVMatice Brian W · Riverview, FLBuilt 2022 · S/N 74520N161RWMcdonald Walter S · Park City, UTBuilt 2006 · S/N 53MN161SAAviation Consultants Inc DBA · San Luis Obispo, CABuilt 2002 · S/N 901-2002N161SEOquinn Timothy M · Tehachapi, CABuilt 2006 · S/N 1027-2006
Back to AD 81-18-04 R2