OpenAirDocs.org
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.

N4520ACoogan Timothy J · Anchorage, AKBuilt 1957 · S/N 22-3827N4520BOhara William P · Atco, NJBuilt 1979 · S/N AA5B1060N4520JRegistered aircraftBuilt 1968 · S/N 28R-30377N4520LWilliams James A · Newark, DEBuilt 1979 · S/N AA5B1062N4520NHurley Peter · Clearwater, FLBuilt 1979 · S/N AA5B1063N4520RBurge John A · Pensacola, FLS/N 28-21222N4520TBrummell Colten Andrew · Hannibal, MOBuilt 1971 · S/N 28-7105216N4520XFlorida Coast To Coast Helicopters Inc · Pompano Beach, FLBuilt 2009 · S/N 12873N45210Domogala David J · Southbury, CTBuilt 1979 · S/N AA5B1076N45211Beloit Aviators LLC · Jefferson, WIBuilt 1979 · S/N AA5B1077N4521C4 Legged Fliers LLC · Brick, NJBuilt 1979 · S/N AA5B1071N4521JSpringer Louis A · Bellflower, CAS/N 28R-30378N4521LCarey Daniel · Rockville Centre, NYS/N AA5B1072N4521NMehraban Seyed Habib · Los Angeles, CABuilt 1979 · S/N AA5B1073N4521RLenz Gregory K · Everton, MOBuilt 1965 · S/N 28-21223N4521TSpencer Kevin L DBA · Bend, ORBuilt 1972 · S/N 28R-7235077N4521VPirri Anthony N · East Falmouth, MABuilt 1979 · S/N AA5B1075N4521XClemmons Philip B · Madison, ALBuilt 1975 · S/N 28-7615023N4521YKron Howard H · Clara City, MNBuilt 1966 · S/N 25-4072N4521ZWeichert Eric S · Janesville, MNBuilt 1960 · S/N 22-8008N45223Moran Timothy P · Acworth, GABuilt 1979 · S/N AA5B1088N45226Gildersleeve Robert · Storrs, CTBuilt 1979 · S/N AA5B1089N4522ABryant Stephen · Anchorage, AKS/N 22-3829N4522BKlifman Dustin · Muskegon, MIBuilt 1979 · S/N AA5B1081N4522LGaines Charles C · Fernandina, FLBuilt 1979 · S/N AA5B1084N4522NFrieling Judson D · Houston, TXBuilt 1979 · S/N AA5B1085N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028N4522YAerial Messages Leasing Co · Longwood, FLBuilt 1966 · S/N 25-4030N4522ZCandeletti James · Forked River, NJBuilt 1979 · S/N AA5B1087N4523CShelton Agri Services Inc · Hereford, TXBuilt 1953 · S/N 25467N4523DFalk Thomas M · Silver Spring, MDBuilt 1979 · S/N AA5B1091N4523JN4523j LLC · Wilmington, DEBuilt 1968 · S/N 28R-30381N4523RGardner Michael J · Ashland, ILS/N 28-21225N45240Buford Thomas Edwin · Lemoore, CABuilt 1979 · S/N AA5B1112N45248Lewis Steven A · Mesa, AZBuilt 1976 · S/N 177RG1098N45249Porus Joseph B · Oakland, NJBuilt 1979 · S/N AA5B1115N4524BBarbero Matias J · Cape Coral, FLBuilt 1979 · S/N AA5B1098N4524EHarper Michael B · Buena Vista, COBuilt 1979 · S/N AA5B1099N4524KMorris David R · Montara, CABuilt 1979 · S/N AA5B1100N4524NHorejsi Michael E · Castro Valley, CABuilt 1979 · S/N AA5B1103N4524PRegistered aircraftBuilt 1979 · S/N AA5B1105N4524QRegistered aircraftBuilt 1979 · S/N AA5B1106N4524WRichardson Shane D · Pekin, ILBuilt 1979 · S/N AA5B1109N4524XSharp Jacob · El Paso, TXBuilt 1975 · S/N 28R-7635069N4524ZMercer Eric S · Ukiah, CABuilt 1979 · S/N AA5B1111N45250Thiele Klaus U · San Diego, CABuilt 1976 · S/N 177RG1099N45253Dewey Alice · West Palm Beach, FLBuilt 1979 · S/N AA5B1126N4525BCmis N4525b LLC · Carlsbad, CABuilt 1979 · S/N AA5B1116N4525CBeauchard Lucine E · Morehead City, NCBuilt 1979 · S/N AA5B1117N4525FStallknecht William A · San Antonio, TXBuilt 1979 · S/N AA5B1118
Back to AD 81-18-04 R2