OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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.

N402XWeyrauch Paul H · Ray, NDBuilt 1976 · S/N 7035CN403Pescatore Thomas F · Monte Vista, COBuilt 1999 · S/N 1451N4030CAdcock Corey J · Victoria, TXFirst renewal noticeBuilt 1990 · S/N 1544N4030RDsp Investments LLC · Long Beach, CABuilt 1967 · S/N 32-40325N4030UEagle Services Inc · Washington, MIBuilt 1990 · S/N 1545N4031PGarrett Randy L · Pensacola, FLBuilt 2002 · S/N 60374N4031WBering Pacific Ranches Ltd · Foothills AbBuilt 1990 · S/N 1540N4032PTinny Twister Aviation LLC · Fort Myers, FLBuilt 1958 · S/N 23-1508N4032WRegistered aircraftBuilt 1966 · S/N 32-40053N4033BHawkins Nathan C · Pueblo, COS/N 75-32-153N4033RSwanson Terence S · Montrose, COBuilt 1967 · S/N 32-40329N4033TCrop Doctors LLC · Micanopy, FLS/N 1471N4033WHolladay Grant L · Lamesa, TXBuilt 1966 · S/N 32-40055N4033XMcbride William M · New Castle, DEBuilt 1970 · S/N 5133N4033ZSale Reported · Port Alsworth, AKSale reportedBuilt 1963 · S/N 18-7993N4034PKoenig William J · Benedict, MDS/N 23-1510N4034RBryant Jonathan E · Joaquin, TXS/N 32-40330N4034XPrivus Inc · Brooklyn, NYBuilt 1970 · S/N 5134N40353Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1574N4035NTodd Steven G · Binghamton, NYBuilt 1968 · S/N 680162N4035RMoreau Donald G · Dayton, TXBuilt 1970 · S/N 28-5796N4035ZPeninsula Aero Technology Inc · Kenai, AKS/N 18-7995N40363Raider LLC · Joplin, MOBuilt 2011 · S/N 2108N4036ERieger John R · Plevna, MTBuilt 1977 · S/N 18-7809042N4036NJestice Manuel P · Ryder, NDBuilt 1968 · S/N 680023N4036PFiegel Donald H · Ward, ARBuilt 1958 · S/N 23-1512N4036RN4036r LLC · Quinton, ALBuilt 1970 · S/N 28-5663N4036ZHockey Puck LLC · Big Lake, AKBuilt 1963 · S/N 18-7996N40372Gajewski Lillia M · Billings, MTBuilt 1973 · S/N 27-7305135N40374Solo Exteriors Co LLC · Seminole, TXBuilt 1991 · S/N 1668N4037EMathews Brett G · Platte City, MOS/N 18-7809043N4037MJensen Mitchell D · Coeur D Alene, IDBuilt 1947 · S/N 12-2920N4037PLivernois Douglas H · Melrose, FLBuilt 2002 · S/N 465N4038MAlyeska Helicopters LLC · Girdwood, AKBuilt 1990 · S/N 1571MN4038ZLutz Matthew S · Lewistown, MTBuilt 1963 · S/N 18-7999N40398Emerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1590N40399Aviation Academy LLC · Wichita, KSBuilt 1973 · S/N 27-7305163N4039PPetersen Clayton L · Albert Lea, MNBuilt 1958 · S/N 23-1516N4039ZMeeker Airport Inc · Meeker, COBuilt 1963 · S/N 18-8000N403ATNew Horizons Aviation Inc · Goshen, INBuilt 2005 · S/N 40.FC004N403BCSmith Kenneth W · Marble Falls, ARBuilt 1990 · S/N 1539N403CPGreenblatt Steven · Macon, GABuilt 2004 · S/N 3607N403DTTimms Douglass D · Gouldsboro, MEBuilt 1991 · S/N DT-001N403ESPlumdaffy LLC · West Chatham, MAS/N 18280050N403FDFrancesco Tedeschi · Del Mar, CABuilt 1990 · S/N 768N403JREllman Brett M · Cardiff By The Sea, CABuilt 1977 · S/N AA5B0441N403NAWadsworth Chad C · Lake Havasu City, AZBuilt 2017 · S/N 1032N403RRodrian James A Trustee · Grafton, WIBuilt 2009 · S/N 093N403RCSalt Lake Community College · Salt Lake City, UTBuilt 2000 · S/N 819N403SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 172S8295
Back to AD 87-10-06 R1