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.

N7418RJones Clayton S · Boerne, TXS/N 28-21942N7418YArmbrister Justin R · Blue Ridge, TXBuilt 1964 · S/N 30-482N7419FSmith Helicopters Inc · Cotulla, TXBuilt 1977 · S/N 670606N7419GFlycarolina LLC · Concord, NCBuilt 1970 · S/N 17259119N7419PBollfrass William Henry III · Rhinelander, WIBuilt 1961 · S/N 24-2607N7419RDiorio Christopher J · Melba, IDBuilt 1966 · S/N 28-21944N7419WBaker Terry · Mesa, AZBuilt 1977 · S/N M-1973N741BDRitenour John E · Waynesboro, PABuilt 2002 · S/N 1024N741CAHarold F Mowery · Mechanicsburg, PABuilt 1974 · S/N 3191N741CDD & J Training Planes LLC · Logan, UTBuilt 2021 · S/N 40.1230N741CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281790N741DMFrench David · Tucson, AZS/N 28-1080N741DPPleasant Aviation LLC · Mount Pleasant, TXBuilt 1974 · S/N 17264611N741DWCub Driver LLC · Morgan, UTBuilt 2005 · S/N PA0205N741FHammer Thomas · Plantersville, TXBuilt 2011 · S/N 3129N741FLFerrario Michael R · San Rafael, CABuilt 1972 · S/N 28-7225578N741GSReform Friendly Flyers LLC · Buhl, ALBuilt 1970 · S/N 17259111N741HCUp 2011 LLC · Edmond, OKS/N 001N741LClarke Adam M · Lompoc, CABuilt 2004 · S/N 1001N741MAN18356 LLC · Hayden, IDBuilt 2006 · S/N 2361N741MBNelson Aircraft Sales LLC · Austin, MNBuilt 2006 · S/N 70041N741NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881026N741RASkyline Solutions Inc · Deland, FLBuilt 1989 · S/N 2841137N741SSlavick Dennis M · Palm Desert, CAS/N 49N741TJJackson Thomas R Jr · Spearfish, SDBuilt 1964 · S/N 30-477N741WBEastern Kentucky University · Richmond, KYBuilt 2015 · S/N 172S11571N742United States Department Of Agriculture · Cedar City, UTBuilt 1964 · S/N 18-8146N74203Gray David M · Albuquerque, NMBuilt 1946 · S/N 1316N7420GKellum Richard A · Seattle, WABuilt 1970 · S/N 17259120N7420KGonzales Kevin F · Alger, OHBuilt 1950 · S/N 20-330N7420PTurner Bryan R · Corinth, TXBuilt 1961 · S/N 24-2608N7420WN7420w LLC · Halethorpe, MDBuilt 1963 · S/N 28-1308N7420YLegacy Aviation Inc · Stuart, FLBuilt 1964 · S/N 30-484N74218Grumman Tiger LLC · Moorpark, CABuilt 1975 · S/N AA5B-0164N74219Cmcs Aviation LLC · Atlantic Beach, FLBuilt 1975 · S/N AA5B-0165N7421GLibby Matthew P · Castle Hill, MEBuilt 1970 · S/N 17259121N7421JBaker Ronald A · Belgrade, MTBuilt 1968 · S/N 28R-30764N7421VYacuzzi Gerald A · Quinque, VABuilt 1975 · S/N 20-1155N7421WMiller James Robert · Gainesville, GABuilt 1963 · S/N 28-1309N7421YHinkle Anthony Gray · Mineola, TXBuilt 1964 · S/N 30-486N74225Campbell Thomas J III · Good Hope, GABuilt 1975 · S/N AA5B-0166N7422DEvans Clyde Joseph · Muscatine, IABuilt 1957 · S/N 22-5183N7422GLafayette Escadrille Flying Club · Rock Spring, GABuilt 1970 · S/N 17259122N7422RCastillo Alex R · West Covina, CABuilt 1966 · S/N 28-21948N7422VPanto Anthony · Jackson, NJS/N 20-1156N7422ZFarm Air Inc · Astoria, ILBuilt 1965 · S/N 25-3399N74237Carino Jane Liu · Buckley, WABuilt 1975 · S/N AA5B-0169N7423KStricker Edwin C · Lucerne Valley, CABuilt 1950 · S/N 20-333N7423PVarner David C · Atascadero, CABuilt 1961 · S/N 24-2611N7424Stansbury Tracy E · The Dalles, ORBuilt 2006 · S/N 14119C
Back to AD 81-18-04 R2