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.

N5750ZFaux George F 11 · Newcastle, MEBuilt 1963 · S/N 22-9592N57515Peterson Dean · Gothenburg, NEBuilt 1973 · S/N 380-73N57517Du Aircraft Leasing · Green Bay, WIS/N 526-73N57519L & L Flying Inc · Glen Allan, MSS/N 532-73N5751EFlight Tech Inc · Arlington, WAS/N 17271931N5751LWoodward Stephen · Fountain Hills, AZBuilt 1972 · S/N AA1B-0051N5751PKrager Aviation LLC · Perry, UTBuilt 1959 · S/N 24-826N57522Baker Brad L · Salcha, AKBuilt 1973 · S/N 534-73N5752LLamas Frank A · Brackettville, TXBuilt 1972 · S/N AA1B-0052N5752QJackson John E · Oak Harbor, WABuilt 1965 · S/N 3078N5752URiggin Flight Service · Madison, SDS/N 28-26575N57532N57532 LLC · Wasilla, AKS/N 18-7809089N57534Sale Reported · Drake, NDSale reported, pending cancellationBuilt 1978 · S/N 18-7809090N5753FRauch Jack · San Rafael, CABuilt 1968 · S/N 28-25056N5753HLindberg Samuel L · Odebolt, IAS/N 16-364N5753WRegistration Pending · Royse City, TXRegistration pendingS/N 28-1490N5753ZFereday Richard R · Mccall, IDBuilt 1963 · S/N 18-8026N5754DRocca John · Box Elder, SDS/N 22-4454N5754ECox Charles C · Hood River, ORBuilt 1978 · S/N 17271934N5754FStorm Joseph K · Enumclaw, WABuilt 1968 · S/N 28-25057N5754HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-365N5754QHamm Martin C · Southport, NCBuilt 1965 · S/N 3079N5754UAuthement Michael Ray · Pecos, TXBuilt 1969 · S/N 28-26577N5754VWeiser Steven Clark · Hutto, TXBuilt 1966 · S/N MA-20N5754ZKumley William A · Camarillo, CABuilt 1963 · S/N 22-9596N57550Freese Marc Alan · Fulda, MNBuilt 1977 · S/N 18-7709122N57555Norden Paul E · Anchorage, AKS/N 18-7709124N5755DNathan Timothy A · Arnold, MDBuilt 1956 · S/N 22-4455N5755HMccafferty Gerald F · Tumwater, WABuilt 1949 · S/N 16-367N5755UKyzer Aviation Holdings LLC · Fort Mill, SCS/N 28-26579N5755VArnold Alan Dale · Glenwood Springs, COBuilt 1966 · S/N MA-16N5755WSchmidt Mia H · Van Nuys, CABuilt 1963 · S/N 28-1499N5755ZSkibinski James J · Senoia, GABuilt 1963 · S/N 22-9597N57562Sitter Timothy L · Anchorage, AKFirst renewal noticeBuilt 1978 · S/N 18-7809093N5756FStewart Larry E · Seymour, INBuilt 1968 · S/N 28-25059N5756QDominguez Juan · Austin, TXBuilt 1965 · S/N 3080N5756YLamascus Mark S · King City, CAS/N 18-8325N5757EFlex Air Inc · San Diego, CABuilt 1978 · S/N 17271935N5757FWaletzko David L · Avon, MNBuilt 1968 · S/N 28-25060N5757HWahlquist Andrew J · Honey Grove, TXBuilt 1949 · S/N 16-369N5757KRegistered aircraftBuilt 2025 · S/N 70075N5757WN63e LLC · Fallon, NVBuilt 1964 · S/N 28-1527N5758FTipnis Zachary Arjun · Troy, NYS/N 28-25061N5758JBatchelder Wesley · Palacios, TXBuilt 1980 · S/N 17273833N5758PBarr Michael J · Colorado Springs, COBuilt 1959 · S/N 24-834N5758QAviation Forza Inc · Pompano Beach, FLS/N 3081N5758VNelson Mike R · Philip, SDS/N MB-41N5758ZColt 135 LLC · Lexington, NEBuilt 1963 · S/N 22-9600N5759FGelnett Dean A · Lansdale, PABuilt 1968 · S/N 28-25062N5759PDemars Michael · California, MDBuilt 1959 · S/N 24-836
Back to AD 81-18-04 R2