OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N2428MTyrrell Wesley F · Central, AKBuilt 1947 · S/N 12-1661N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64N24296Cc Aviation Inc · Tracy, CABuilt 1977 · S/N 15280201N2429JWolf Gary P · Pahrump, NVBuilt 2001 · S/N 5123N2429KHarris Leritha M · Santa Cruz, CABuilt 1979 · S/N 38-79A0627N2429MTurner Greg W · Delta Junction, AKS/N 12-1663N2429RJones Adam · Fairbanks, AKBuilt 2000 · S/N T20608161N2429SAdams Kelly M · Galveston, TXBuilt 1979 · S/N 18-7909148N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732N242ABBrankov Branimir · Naples, FLS/N 0678N242AFAlagar Volare LLC · Anna, TXBuilt 2003 · S/N 18281183N242AKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 172S11091N242AMZike Jay N · Lindsay, CABuilt 2003 · S/N 2242N242AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13204N242AVN242av LLC · Manassas, VABuilt 1972 · S/N 17260470N242BCElemental Aviation Lc · Wichita, KSBuilt 2011 · S/N 534-2010N242BDDouglass Bryan C · Missoula, MTBuilt 2011 · S/N 40084N242BWLasensky David W · Newtown Square, PAS/N 10214N242CBHarte Mike · Lone Star, TXBuilt 1978 · S/N 24-0459N242CCRecreational Management Inc · Mount Ida, ARBuilt 1997 · S/N 3246095N242CDManly Anderson J · White Salmon, WABuilt 1985 · S/N 1N242CPBeste Robert K · Sauk Centre, MNBuilt 1978 · S/N 24-0715N242DCRedtail Aviation Services LLC · Inglewood, CABuilt 1994 · S/N 0668N242DFForce Dave Jr · Glenwood Springs, COBuilt 2005 · S/N 1N242DGWing Over Aerobatics LLC · Weirsdale, FLBuilt 1995 · S/N 0687N242DKInter Island Yachts Inc · Rncho Pls Vrd, CABuilt 1995 · S/N 0689N242DSSneed Jason C · Spanish Fork, UTBuilt 1997 · S/N 001N242DTSherlock William H · Greenbrae, CABuilt 1997 · S/N LRC-1N242ENorman Brian D · Roseau, MNBuilt 1973 · S/N 17261819N242EBEb Marine LLC · Riviera Beach, FLBuilt 1967 · S/N 32-40229N242EEOrlowski Micheal A · Gold Hill, NCBuilt 1978 · S/N 38-78A0494N242EPEpic Aviation Inc · New Smyma Beach, FLBuilt 2024 · S/N 172S13243N242EX242ex LLC · West Palm Beach, FLS/N 32-7940234N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042N242HSpruce Creek Tiger LLC · Port Orange, FLBuilt 1977 · S/N AA5B0514N242HRShine Dylan · Jupiter, FLBuilt 1998 · S/N 159N242JMLitsky Steven H · University Place, WABuilt 1994 · S/N 0677N242JWAviation Leasing Co LLC · Ooltewah, TNBuilt 2019 · S/N 172S12279N242KMPlane Care Inc · Weston, FLBuilt 1977 · S/N 32-7740111N242LESky King Aviation Services Inc · Ardmore, OKBuilt 1990 · S/N 1N242LHMatthews Micheal S · Reno, NVBuilt 1994 · S/N 0673N242LPDavenport Rebecca · Fresno, CABuilt 2000 · S/N 24340N242MEMike Echo Ventures LLC · Coral Gables, FLBuilt 2000 · S/N 20608112N242MGHelo 1 LLC · Anchorage, AKBuilt 2006 · S/N 11134N242MPWestwood Dave · Red Lodge, MTBuilt 1994 · S/N 0660N242MZBechara Nizar E · Columbia, MDBuilt 1999 · S/N 0732N242NDHaye Patrick W · Minot, NDBuilt 1999 · S/N 2842052N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137N242PHoeme Eric L · Leoti, KSBuilt 1967 · S/N 28-10998
Back to AD 81-18-04 R2