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.

N8684DScott Lonnie L · Nikiski, AKBuilt 1958 · S/N 18-6289N8684EMotl Gregory C · Humble, TXBuilt 1976 · S/N 28R-7635195N8684WFleming Joanne M · Davenport, WABuilt 1963 · S/N 28-10216N86854Moore Planting Co Inc · Cary, MSBuilt 1974 · S/N 6-74N86863Pruitt Leland L · Jones, LABuilt 1974 · S/N 36-74N8686WSchwalbach Nicholas J · Saint Paul, MNBuilt 1964 · S/N 28-10218N8686YAdvanced Aviation LLC · Midlothian, VABuilt 1969 · S/N 30-1831N86872Chupito Sabrocito LLC · Paso Robles, CABuilt 1974 · S/N 1028-74N86879Knik Flying Club LLC · Anchorage, AKBuilt 1975 · S/N 856-75N8687CMorgigno Daniel A · Mission Viejo, CABuilt 1953 · S/N 22-1358N8687VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 184-75N8687WJaques Wayne R · North Little Rock, ARBuilt 1963 · S/N 28-10199N86883High Exposure Inc · Wilmington, DEBuilt 1974 · S/N 680-74N86885Mason Peter Trustee · Santa Paula, CABuilt 1974 · S/N 37-74N8688DHarmon Mike D · Mansfield, SDS/N 18-6295N8688VHawkeye Aviation LLC · Newport, ARBuilt 1975 · S/N 1096-75N8688WCameron Vincent A · Menifee, CABuilt 1966 · S/N 28-10795N8688YMager Robert R · Quakertown, PABuilt 1969 · S/N 30-1834N86890E-Commerce Education Foundation · Tulsa, OKBuilt 1974 · S/N 443-74N86892Goodman Jack · Memphis, TNBuilt 1974 · S/N 296-74N8689VZacheis Henry M · Fairbanks, AKBuilt 1975 · S/N 841-75N8689YBlue Sky Aviators LLC · Winnebago, ILBuilt 1969 · S/N 30-1835N868BBahrns Phyllis Alyene · Effingham, ILBuilt 2007 · S/N 71067N868JDBratton Charles M · Gatesville, TXBuilt 2012 · S/N 070-133/134-941N868KWeber Jennifer R · Bryan, TXBuilt 2011 · S/N BLM-2N868KFSmith Jason · Calliham, TXBuilt 2000 · S/N 3124N868LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1903N868MMUhl Gregory R · Columbus, MSBuilt 2019 · S/N 81733N868PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843949N868PKYellow Therapy LLC · Kalispell, MTBuilt 1982 · S/N 18-8209021N868RTMartin John D · Billings, MTS/N 18-7809119N868SAS O W Aviation LLC · Crystal River, FLS/N 17266439N868SPWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 172S8128N868TBSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9311N868UInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020268N868XGuhr Robert · Stockholm, NJBuilt 2006 · S/N 2351N86901Rudderow Preston Trustee · Anchorage, AKBuilt 1974 · S/N 23-74N86911Schneberger Bart A · Nome, AKBuilt 1974 · S/N 25-74N86919Latham Ray H · Raymond, WABuilt 1946 · S/N 1281N8691COrtet Craig A · Etna, WYBuilt 1953 · S/N 22-1331N8691VAviation Specialists LLC · Wilmington, DES/N 1097-75N8691YVan Bladeren John A · Tigard, ORBuilt 1969 · S/N 30-1837N86928Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 32-74N8692CTexas Air And Space Museum Inc · Amarillo, TXBuilt 1992 · S/N 001N8692DBryan Kirk J · Big Timber, MTS/N 18-6298N8692VLohr Martin J · Petersburg, AKBuilt 1975 · S/N 831-75N8692YTedder Ag Technologies Inc · Walsh, COBuilt 1969 · S/N 30-1838N86936Lewis Aviation Inc · Wilmington, DEBuilt 1974 · S/N 444-74N8693VMichael A Levenhagen · North Fort Myers, FLBuilt 1975 · S/N 185-75N8693WPack Timothy W · Blacklick, OHS/N 28-10796
Back to AD 81-18-04 R2