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.

N6919NNicholas Dagmar H · Uniontown, OHBuilt 1968 · S/N 680179N6919PMunroe Consulting · Ocala, FLBuilt 1962 · S/N 24-3143N6919VKimzey Robert R · Cypress, TXBuilt 1975 · S/N 22-1299N6919WN6919w LLC · Key West, FLBuilt 1965 · S/N 28-21090N691BARotor Ops 269 LLC · Wilmington, DEBuilt 2006 · S/N 11168N691BEWester Joshua · Emmett, IDS/N 1309N691DBRvrh Ventures LLC · San Antonio, FLS/N 177RG1314N691DLJohnson Boyd D · Preston, IDBuilt 1992 · S/N 20192N691DSNelson Travis K · Hamilton, MTS/N 20199N691FLKelley Keith B · Forney, TXS/N 28-7125628N691JATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13595N691JCFlabob Airport LLC · Jurupa Valley, CABuilt 1978 · S/N VAC-117-78N691KWHoegg Thomas K · Mountain Home, IDS/N 20985N691LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881197N691RPRegistration Pending · Mount Holly, VTRegistration pending, canceledBuilt 1969 · S/N 28R-35019N691SPGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1999 · S/N 172S8100N691TCSpartan National Holdings LLC · Missoula, MTBuilt 1999 · S/N 172S8225N691WEagle Simulator LLC · Lake Oswego, ORBuilt 1982 · S/N 17275576N69200Propel Air LLC · Pottstown, PABuilt 1978 · S/N 15282548N69204Fca Flight Center Inc · Fitchburg, MABuilt 1978 · S/N 15282552N69205Oklahoma State University · Stillwater, OKBuilt 1978 · S/N 15282553N69207Horman Richard Scott · Las Vegas, NVBuilt 1978 · S/N 15282555N6920CKiesel James L · Hanford, CABuilt 1969 · S/N 690065N6920GValley Boys LLC · Lakeville, MNBuilt 1985 · S/N 28-8590065N6920NHodgman Gary W · Greenville, TXBuilt 1968 · S/N 680142N6920PStanley Travis Navar · Dundee, OHBuilt 1960 · S/N 24-2054N6920QNeff Marcus J · Tigard, ORBuilt 1967 · S/N MA-273N6920VPjs Enterprises · Havre, MTBuilt 1975 · S/N 22-1300N69211Nelson John · Lusby, MDBuilt 2012 · S/N 81632N69212Briner Micah E · Martinsville, INBuilt 1978 · S/N 15282560N69213Weedhopper Aviation LLC · Sparks, NVBuilt 1978 · S/N 15282561N6921BKnepp Gerald L · Milroy, INBuilt 1956 · S/N 22-4197N6921NBower Edwin M · Norco, CABuilt 1968 · S/N 680180N6921PNormark Ronald L · Weirsdale, FLBuilt 1960 · S/N 24-2055N6921VLebow Kirk · Clovis, NMBuilt 1975 · S/N 22-1301N69228Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282573N6922JSystematic Management And Flight Training LLC · Kankakee, ILBuilt 1976 · S/N 28-7690431N6922NPetrie Chris · Titusville, FLBuilt 1968 · S/N 680143N6922UStrategic Aviation Assets LLC · Havre, MTBuilt 1964 · S/N 292N6922WRobirds Ryan E · Wheelersburg, OHS/N 28-21095N69232Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282575N69238Hall David D · Des Moines, WABuilt 1978 · S/N 15282579N6923BWitzel John F Jr · Frenchglen, ORBuilt 1956 · S/N 22-4199N6923DCline Patrick G · Granbury, TXBuilt 1957 · S/N 22-4851N6923KLeocha Anthony J · Hampstead, NHBuilt 1950 · S/N 20-26N6923NTurner William H · Parkersburg, WVBuilt 1968 · S/N 680181N6923PLopez Ruben Arellano · Nogales, AZS/N 24-2057N6923QWelch William Trustee · Washington, UTBuilt 1967 · S/N MA-279N69247Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282583N6924HJeea Aviation LLC · Tyler, TXBuilt 1975 · S/N 17265647
Back to AD 81-18-04 R2