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.

N7880GGhegan John · Wilmer, ALBuilt 1970 · S/N 17259580N7880KMattingley Kenneth R · Willow, AKBuilt 1953 · S/N 22-937N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904N78819Houdek Dennis E · Roseburg, ORBuilt 1947 · S/N 111593N7881GSmith John T · Greenfield, INBuilt 1970 · S/N 17259581N7881WEast Crest Management LLC · Eastvale, CABuilt 1964 · S/N 28-1905N78825Houdek Dennis E · Roseburg, ORBuilt 1947 · S/N 111599N78827Latshaw Elizabeth H · Catawba, NCBuilt 1947 · S/N 11-1601N78828Dotter Henry C · North Pole, AKS/N 11-1602N7882CKeck Joseph S · Las Vegas, NVS/N 28-7625087N7882PWaters Robert D · Albuquerque, NMBuilt 1962 · S/N 24-3110N7882VSlepian Isaac J · El Dorado Hills, CABuilt 1965 · S/N 2844N78830Frederick Wayne Schultz · Bradley, ILBuilt 1968 · S/N 17257782N78834Barron Ted L · Hoover, ALBuilt 1968 · S/N 17257783N7883DMeierotto Marty · Two Rivers, AKBuilt 1957 · S/N 18-6043N7883PFinke Michael C · Pleasant Prairie, WIBuilt 1962 · S/N 24-3111N7883TMarlu Enterprises Inc · Foristell, MOBuilt 1991 · S/N 2211N7883VFranks Gary E · Ponder, TXBuilt 1964 · S/N 2845N7883WStack Brian James · Paso Robles, CABuilt 1964 · S/N 28-1907N7883YHoward Jerry W · Snellville, GABuilt 1965 · S/N 30-968N78842Helice Sarcelle LLC · San Antonio, TXBuilt 1968 · S/N 17257787N78846Aero Investors Lc · Jackson, MIS/N 17257788N78850Karpik Richard Paul · Grand Rapids, MNBuilt 1968 · S/N 17257790N78856Bedwell Christopher A · Paso Robles, CABuilt 1968 · S/N 17257791N78857Hunt Thornton Trevon · Aurora, COBuilt 1968 · S/N 17257792N7885DLindstrom Daniel G · Somerset, WIBuilt 1957 · S/N 18-6045N7885HFisher Joel F IV · Rockville, MDS/N 12-788N7885WCp Authority LLC · Poulsbo, WABuilt 1964 · S/N 28-1909N7885YKregel Steven · Garnavillo, IABuilt 1965 · S/N 30-970N78861Wood Jeffrey A · Willis, TXS/N 253N78865Gingras Carl A · Avondale, COS/N 2880N78869Zullo Thomas L · Lindenhurst, NYBuilt 1964 · S/N 2884N7886GArctic Barnabas Ministries Inc · Kenai, AKBuilt 1970 · S/N 17259586N7886VLowenhaupt Michael J · Metairie, LABuilt 1964 · S/N 2848N7886WChelena Eric D · San Antonio, TXBuilt 1964 · S/N 28-1910N78871Rosenfeld Kristina M · Eureka, CABuilt 1964 · S/N 2886N78873Mesner Steven M · Tomah, WIBuilt 1964 · S/N 2888N78875Janssen Christopher R · Ankeny, IABuilt 1964 · S/N 2890N78877Obrien Garrett G · Sheep Ranch, CABuilt 1965 · S/N 254N7887GLandrum Erik · Austin, TXBuilt 1970 · S/N 17259587N7887P7887papa LLC · Glenwood Springs, COBuilt 1962 · S/N 24-3116N7887WDepp Gregory B · Ft Worth, TXBuilt 1964 · S/N 28-1911N7887YAskins Jack C · Wichita Falls, TXBuilt 1966 · S/N 30-973N78880Coma Aviation LLC · Buckhannon, WVBuilt 1964 · S/N 2895N78882Triplat Bonnie E · Rosamond, CABuilt 1964 · S/N 2897N78884Cooke Daniel S · Kanarraville, UTBuilt 1964 · S/N 2899N78888Woodard Ben C · Truckee, CABuilt 1964 · S/N 2903N7888MMonpas Mark E · Anderson, CABuilt 2011 · S/N 72599N7888WLashinski Michael J · Monument, COBuilt 1964 · S/N 28-1912N7888YBurkel Robert G · Hemet, CABuilt 1966 · S/N 30-975
Back to AD 81-18-04 R2