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.

N4449JSinatra Anthony J · Glendale, AZBuilt 1967 · S/N 28-22854N4449MMoore David P · Chugiak, AKBuilt 1947 · S/N 12-3401N4449RMorrow David · Maynardville, TNBuilt 1978 · S/N R18200602N4449ZStenga James E · Soldotna, AKBuilt 1969 · S/N 18-8796N444APSmith Robert S · Orlando, FLBuilt 1975 · S/N 177RG0787N444AWHangar 22 LLC · Wilmington, DEBuilt 1995 · S/N 373-95N444BLTri Air LLC · Monette, ARBuilt 1966 · S/N 99N444BWAmigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11254N444CPMercure Ryan K · Eads, TNBuilt 1963 · S/N 30-230N444CRUtah State University · Logan, UTBuilt 2012 · S/N 4578N444CSStover Charles S · Ft Lupton, COBuilt 2001 · S/N 3994N444CTLeseviciute Audrone · Stamford, CTBuilt 2004 · S/N 3232032N444DBBalint Jozef · Fort Worth, TXBuilt 1978 · S/N 7-0106N444DDHardin Donald D Trustee · Kirkwood, MOBuilt 1983 · S/N 1423N444DJSims George W III · Eclectic, ALBuilt 1970 · S/N 700075N444DPStratospheric Ventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 28R-7435167N444DVSky High Helicopters LLC · Camarillo, CABuilt 2006 · S/N 1662N444DXRudeeair LLC · New Bern, NCBuilt 2011 · S/N SFG035N444DYCox Thomas A · Franksville, WIBuilt 2007 · S/N 016269N444EDunker Quinn E · Morse Bluff, NEBuilt 1963 · S/N 0217N444EEVaughn Stewart C · West Jordan, UTBuilt 1974 · S/N 17263906N444FDJohnson Heimana J · San Marcos, CABuilt 1994 · S/N 2082N444FEN444fe LLC · Stuart, FLBuilt 1979 · S/N ME-142N444FGFrancis Andrew J III · Spring, TXBuilt 1981 · S/N 28-8190283N444FRRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11577N444FWKuntz Clark · Tallahassee, FLBuilt 1977 · S/N 32R-7780425N444HSCampi Curtis A · Boulder City, NVS/N T-1978N444HUDorsey Sage · Bend, ORBuilt 1998 · S/N 1396N444HYHutton Mark · Denison, TXBuilt 2006 · S/N 2353N444JERanchlands LLC · Hyattville, WYBuilt 2006 · S/N 58N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013N444JLColby Christopher F · Hampton, VABuilt 1966 · S/N 28-22224N444JTFilho Aniz Rasslan · Payson, AZBuilt 2001 · S/N 2973N444KCEdelman Douglas M · Sabetha, KSBuilt 1973 · S/N 28-7325504N444KPPerkins Kevin J · Wichita Falls, TXBuilt 2014 · S/N 92069N444KRSmith Wylie J · Hawthorne, FLS/N 690068N444LCPiper Cherokee LLC · Leesburg, VABuilt 1977 · S/N 32-7740047N444LMHumphrey William E · Lyndonville, VTBuilt 1966 · S/N 28-22118N444LWWinn Larry V · Tucson, AZBuilt 1998 · S/N 2163N444MAFirst Order Aeronautics LLC · Lees Summit, MOBuilt 2002 · S/N 1HUN444MGGeorgia Aviation Authority · Eastman, GABuilt 2023 · S/N 4496562N444MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1989 · S/N MM1N444MRBuxbaum Mark Edward · Hot Springs, SDBuilt 1995 · S/N 563N444MTBill Mcgowan Inc · Covington, LABuilt 1974 · S/N 2079N444NXAce Aviation LLC · Mankato, MNBuilt 2000 · S/N 419-2000N444PFRegistered aircraftBuilt 1979 · S/N 543-79N444PHLansing Community College · Mason, MIBuilt 1990 · S/N 1578N444PKRegistered aircraftBuilt 2005 · S/N 1364N444PPCoyne Greg · Hondo, TXBuilt 1969 · S/N 17258278N444PWMeyer Renee Brilhante · Lafayette, INFirst renewal noticeBuilt 1987 · S/N 12
Back to AD 81-18-04 R2