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.

N648WBHunt Billy Dean · Rowland, NCS/N 22021CN64908Fauver Russell J · Hartsville, SCBuilt 1978 · S/N 15281470N6490DCampbell James W · Joshua, TXBuilt 1979 · S/N 17272832N6490QSuchting Carl J · Little Egg Harbor, NJS/N 680032N6490RDunn Christopher E · Amana, IAS/N 28-21681N64912Suburban Air Corporation · Castro Valley, CABuilt 1978 · S/N 15281473N64915Northwoods Air LLC · Orono, MEBuilt 1982 · S/N 17275649N64918Loeser Harold · Boca Raton, FLBuilt 1982 · S/N 17275651N64919Hawk III Flyers Club · Republic, PABuilt 1973 · S/N 17262850N6491JEleven X Club Inc · Jeffersonville, INBuilt 1968 · S/N 28-4922N6491RGonzales Christian J · Dallas, TXBuilt 1966 · S/N 28-21683N6491UAllen Todd C · Abingdon, VABuilt 1962 · S/N 2238N6491WHuddleston Ronnie L · North Vernon, INBuilt 1965 · S/N 28-20567N6492ELeadmon Lorren Dale Jr · Mechanicsville, MDBuilt 1978 · S/N 17272024N6492GState Of North Carolina · Raleigh, NCBuilt 2004 · S/N 18281411N6492RFagerhaug Jeffrey · Orangevale, CABuilt 1966 · S/N 28-21684N64939Street Paul G · Anniston, ALBuilt 1978 · S/N 15281487N6493JReischmann Jonathan · Palm Bay, FLS/N 28-4924N6493RReifschneider Jay S · Patterson, CABuilt 1966 · S/N 28-21685N64942Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281489N64943Tipton Donald Jeffrey Sr · Maryville, TNBuilt 1982 · S/N 17275657N64944Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15281490N64949Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15281494N6494JKennedy Quincy A IV · Florence, SCBuilt 1968 · S/N 28-4925N6494PPiehl Deborah C · Saint Petersburg, FLS/N 24-1614N6494RTurner Manley W Jr · Fredericksburg, VABuilt 1966 · S/N 28-21686N6494ZSoaring Club Of Houston · Waller, TXBuilt 1962 · S/N 25-2015N6495JStp Flight LLC · Saint Paul, MNBuilt 1968 · S/N 28-4926N6495PBarry Steven H · Monticello, UTS/N 24-1615N6495QBaker Chad W · Forney, TXBuilt 1967 · S/N 680037N6495UOtto David L · Lacey, WABuilt 1962 · S/N 2242N6495WScheibinger Alois E · Oshkosh, WIBuilt 1964 · S/N 28-20571N64962Wingsleasing LLC · Wichita, KSBuilt 1982 · S/N 17275659N64964Dodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 17275660N64966Hill Mark T · Gloucester, VABuilt 1982 · S/N 17275661N6496JBudke Kris J · Osceola, WIBuilt 1968 · S/N 28-4928N6496LTurn Key Aviation LLC · North Las Vegas, NVBuilt 1980 · S/N 15284420N6496UWeaver Jimmie G · Winston Salem, NCS/N 2243N64971R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281505N6497AHenry Mark Alan · Dickinson, TXS/N 38-78A0441N6497UPointer James E · Cumming, GAS/N 2244N64985Keenan Jim · Neenah, WIBuilt 1978 · S/N 15281512N64987Stanford Jay J · St Marys, GAS/N 15281514N64989Verderame Robert A · Metairie, LABuilt 1978 · S/N 15281516N6498FWisener Randall G · Addison, ALBuilt 1979 · S/N 17273232N6498JKvistad Jerome L · Coon Rapids, MNBuilt 1968 · S/N 28-4930N6498PSinor Delbert · Ozark, MOS/N 24-1618N6498QShartle Wesley P · Fredericksburg, PABuilt 1967 · S/N 680040N6499PHoward John · Canon City, COBuilt 1959 · S/N 24-1620N6499QWhiteside Kim D · Decatur, ILBuilt 1967 · S/N 680041
Back to AD 81-18-04 R2