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.

N616PCPork Chop Aviation II LLC · Hilliard, OHBuilt 2023 · S/N 28020117N616RHangar 21 Aviation Inc · Orange, CABuilt 2005 · S/N 10787N616RSHubert Richard A · Fowlerville, MIBuilt 2012 · S/N 700N616SFAmelia Reid Aviation LLC · San Jose, CABuilt 1980 · S/N 172RG0740N616SKSuperior Flying Services LLC · Superior, WIBuilt 1979 · S/N 17273381N616SRBarendregt Melvin E · Heyburn, IDS/N 24-1800N616TBChristofferson Kevin J · Fruita, COBuilt 2006 · S/N 20983N616TKScano James · Gunter, TXBuilt 2018 · S/N 73509N616VTNamendorf Michael · New Hyde Park, NYBuilt 1979 · S/N 28-7916500N616WDHalama Patrick J · Whitehall, WIBuilt 2006 · S/N 90669N61700Torres Ramon L · Mulberry, FLS/N 17264741N61701Jls Aviation LLC DBA · Fredericksburg, VABuilt 1975 · S/N 17264742N61703Beising Steven · Las Vegas, NVBuilt 1975 · S/N 17264744N61704Glick Mervin L · Stanardsville, VABuilt 1975 · S/N 17264745N61707Spartan National Holdings LLC · Missoula, MTBuilt 1975 · S/N 17264747N61709Caldwell Clifton · Sterling City, TXBuilt 1975 · S/N 17264748N6170JSeeler John A · Bristol, NHBuilt 1976 · S/N 28R-7635316N6170LCampbell Phillip · Fort Worth, TXS/N AA1-0370N6170MRothe Zachary W · Riverside, CABuilt 1978 · S/N 7179CN6170PMaurer Bruce C · Power, MTBuilt 1959 · S/N 24-1271N6170SNice Flight LLC · Medford, ORBuilt 1980 · S/N R18201637N61710Bob Hoover Academy Inc · Salinas, CABuilt 1975 · S/N 17264749N61713Miller Melanie L · Spanaway, WABuilt 1975 · S/N 17264750N61718Ortman Bernard R · Bozeman, MTBuilt 1975 · S/N 17264753N6171LGoode Stephen C · Canton, TXBuilt 1970 · S/N AA1-0371N61727Mays Gloria J · College Station, TXBuilt 1975 · S/N 17264755N6172DBlue Spruce Aviation LLC · Fairview Park, OHBuilt 1979 · S/N 17272617N6172LKantor Dimitry · Essex, MDBuilt 1970 · S/N AA1-0372N61733Pan Air Flying Club Inc · Miami, FLBuilt 1975 · S/N 17264760N61737Executive Flight Institute LLC · Murrieta, CABuilt 1975 · S/N 17264763N61738Finn Development LLC · Kaysville, UTBuilt 1975 · S/N 17264764N61739Southern Aero LLC · Homestead, FLS/N 17264765N6173DArs Logistics LLC · Hackettstown, NJBuilt 1957 · S/N 22-4820N6173PSwenson James A · Lake Point, UTBuilt 1959 · S/N 24-1274N6173WDiaz Jose O · Ramey, PRBuilt 1964 · S/N 28-20190N61743Carruth John T · Danvers, MNBuilt 1975 · S/N 17264768N61748Zapata Raymond E · Cabo Rojo, PRBuilt 1975 · S/N 17264772N6174DOtoole Makena · Cordova, AKBuilt 1957 · S/N 22-4821N6174LHanson Alan L · Manchester, MIS/N AA1-0374N6174PAbernathy Larry D · Vernon, TXBuilt 1959 · S/N 24-1275N6174RLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 172RG0103N61752Lee Robert Eric · Charleston, WVBuilt 1975 · S/N 17264774N61755K E F Enterprises · Plymouth, MABuilt 1975 · S/N 17264777N61759Watkins Joe C · Albany, GABuilt 1975 · S/N 17264780N6175GKimber 123 Holdings LLC · Morgantown, WVBuilt 1979 · S/N 17273574N6175HLafferty Dietrich Ian · Brooklyn, NYBuilt 1979 · S/N 15284138N6175QKingsky Flight Academy LLC · Lakeland, FLS/N 15285184N6175TNewell John D · Cleveland, TXBuilt 1994 · S/N RV-4-2722N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208N61760Little Duane V · Puyallup, WABuilt 1975 · S/N 17264781
Back to AD 81-18-04 R2