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.

N8802RPacific Kota LLC · Beresford, SDBuilt 1981 · S/N DW-1-0018-81N8802WRegistration Pending · San Juan, PRRegistration pendingBuilt 1964 · S/N 28-10248N8802YMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0019-81N8802ZMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-1002081N8803Lindsay Lori K · Kenai, AKBuilt 1973 · S/N 472-73N88037Willke Sue E · Sewickley, PAS/N 15654N88038Quirk Charles L · Lake Charles, LABuilt 1946 · S/N 15655N88039Chapman Jeffrey C · Brownsburg, INBuilt 1946 · S/N 15656N8803DWhite Jacob · Soldotna, AKBuilt 1958 · S/N 22-5971N8803FAg Helicopters Inc · Ft Collins, CORegistration revokedBuilt 1962 · S/N 0134N8803RMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0024-81N8804Hail Jerry D · Keatchie, LABuilt 1973 · S/N 74-73N88047Rjr Airdrome Inc · Dover, DEBuilt 1974 · S/N 1036-74N8804MKruse Paul L DBA · Colfax, ILBuilt 1981 · S/N DW-1-0030-81N8804NCarbon Regional Aero Club · Lehighton, PABuilt 1969 · S/N 28-25649N8804PJohnsen Christian · Lake Havasu City, AZBuilt 1975 · S/N BH-120-338N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N88055Lake Air Academy LLC · Richland, MIBuilt 1974 · S/N 715-74N88057Registered aircraftBuilt 1974 · S/N 716-74N88059Tidewater Soaring Society · Windsor, VAS/N 72-74N8805CSandifer Steve R · Barnwell, SCBuilt 1953 · S/N 22-1419N8805J8805 Partners LLC · Oklahoma City, OKBuilt 1965 · S/N 28-2755N8806Loyd Robert Oliver Parke · Wallingford, KYBuilt 1973 · S/N 364-73N88061Stoican Steve G · Ryegate, MTS/N DW-1-0045-81N88063Evenson Gabriel J · Fargo, NDS/N 461-74N88065Obx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 460-74N88066Nightingale Patrick R · Lakewood, CABuilt 1974 · S/N 1037-74N8806CGribbins Aviation LLC · Campbellsville, KYBuilt 1953 · S/N 22-1420N8806JLytle Hugh R · Senoia, GABuilt 1965 · S/N 28-2756N8806KMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0041-81N8806LMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0042-81N8806NHorne Terry A · Carefree, AZBuilt 1969 · S/N 28-25652N8806WKennemer Mark · San Angelo, TXBuilt 1964 · S/N 28-10351N8807Potter David · Huntley, ILBuilt 1973 · S/N 473-73N88078Khm Investments Inc · Lehi, UTBuilt 1974 · S/N 464-74N88079East Hill Flying Club Inc · Ithaca, NYBuilt 1974 · S/N 1038-74N8807DGorski Tim B · Larsen, WIBuilt 1958 · S/N 22-5975N8807JNorris Dana G III · Zanesville, OHS/N 28-2757N8807NTruax James D · Roanoke, INBuilt 1969 · S/N 28-25653N8807WSimon Randall V P · Fairbanks, AKBuilt 1966 · S/N 28-10803N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N8807ZMadsen Travis E · New Underwood, SDBuilt 1981 · S/N DW-1-0049-81N88081Butler Julie L · Los Osos, CABuilt 1974 · S/N 718-74N88083N3542w Inc · Wilmington, DEBuilt 1974 · S/N 719-74N88085Poulson Daniel J · Anchorage, AKBuilt 1974 · S/N 722-74N88086Saliba Eric · Mineola, NYBuilt 1974 · S/N 1039-74N8808BSemple Gary W · Flaxville, MTBuilt 1981 · S/N DW-1-0050-81N8808DDwight Thomas W · Castalia, OHBuilt 1958 · S/N 22-5977N8808JCoulliette Brian K · Jacksonville, FLBuilt 1965 · S/N 28-2758N8808WHolysz Matthew M · Vicksburg, MIBuilt 1964 · S/N 28-10353
Back to AD 81-18-04 R2