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.

N8845KVan Bortel Aircraft Inc · Arlington, TXBuilt 2012 · S/N 18282332N88465Castleberry Inc · Ekalaka, MTBuilt 1974 · S/N 791-75N88467Atwood Christopher M · Brownsburg, INBuilt 1974 · S/N 163-75N8846CBranigan Leslie K · Amarillo, TXS/N 22-1460N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804N8846LN8846l LLC · Homestead, FLBuilt 1971 · S/N 25-5357N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697N8846PLecrone Gregory S · Granbury, TXBuilt 1965 · S/N 24-4301N8846WMosby Eric M · Tallahassee, FLBuilt 1964 · S/N 28-10397N88473A C E Aviation Inc · Ashton, IDBuilt 1974 · S/N 306-75N88476Bmg Aviation Inc · Bloomington, INBuilt 1974 · S/N 495-75N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75N8847CBlumenberg Donald D · Fulton, SDBuilt 1953 · S/N 22-1459N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126N8847JFlw LLC · Sandpoint, IDS/N 28-2805N8847MTravel Air LLC · Chico, CABuilt 1964 · S/N TD-575N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699N8847PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1965 · S/N 24-4302N8847WCitro Michael A · Oakley, CABuilt 1964 · S/N 28-10398N8848CLeppert James J Trustee · Dickey, NDBuilt 1953 · S/N 22-1464N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806N8848LSoaring Society Of Dayton Inc · Waynesville, OHBuilt 1971 · S/N 25-5359N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700N8848WHocken David L · Avoca, IABuilt 1964 · S/N 28-10400N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907N88497Airspace Aerial Media LLC · Saint Louis, MOBuilt 1946 · S/N 16121N8849CFitts David A · Salem, ORBuilt 1953 · S/N 22-1463N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807N8849MGuertin Jim B DBA · Lincoln, CABuilt 1969 · S/N 28-11321N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701N8849WAtchison Walter L · Los Alamos, NMBuilt 1964 · S/N 28-10401N884ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496321N884BCBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 172S10545N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876N884CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282084N884DJohnson David L · Blaine, MNBuilt 2010 · S/N 80653N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N884EFChudy Zbigniew P · Southington, CTBuilt 1999 · S/N 884N884EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12808N884FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 4496250N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77N884MManning Michael · Bakersfield, CABuilt 2006 · S/N 335N884MWWarfel Michael G · La Verne, CABuilt 2009 · S/N 81525N884PSSpainhower Paul Allex · Taylorsville, UTS/N 2318N884RVDannebrock Paul W · Lockport, NYBuilt 2012 · S/N 90884N884SADamico Frank J · Pittsburgh, PABuilt 2003 · S/N 0037N884WGVandermay Brandon · Winnemucca, NVBuilt 1994 · S/N 94-0001N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703
Back to AD 81-18-04 R2