OpenAirDocs.org
AD 85-23-07

Registered aircraft · 22,934

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

N1001JBowmar Bruce C · Oxnard, CAS/N 24-3095N1001MRocky Mountain Ventures Inc · Cheyenne, WYBuilt 1970 · S/N 17259401N1002MSchuler Mark E · Columbia, ILBuilt 1970 · S/N 17259402N1003FChyatte Douglas · Saint Joseph, MOBuilt 1981 · S/N 24-1161N1004MReid Brian · Boise, IDBuilt 1970 · S/N 17259404N1005BRucker Casey J · West Linn, ORBuilt 1987 · S/N 4608091N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291N1006WFadem Justin Andrew · Williamsville, NYBuilt 1980 · S/N 24-1069N10074Linder Matthew L · Kalkaska, MIS/N 24-3096N1007NNewberg Edgar T · Hector, MNBuilt 1981 · S/N 24-1098N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052N1007THollar Larry · Winston Salem, NCBuilt 1973 · S/N 18262411N1007XD&R LLC · Emory, TXS/N 34-7570182N1008CBat Flying LLC · Blue Earth, MNBuilt 1981 · S/N 24-1100N1008LWilson Jeffrey M · Upper Arlington, OHBuilt 1981 · S/N 24-1103N1008MHottenstein William R · Kingston, PABuilt 1970 · S/N 17259408N1009CFord Richard B · Hendersonville, NCBuilt 1981 · S/N 24-1105N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030N100FPFlying Particles Inc · Livermore, CABuilt 1974 · S/N 18262957N100GFMenke Rex A · Medical Lake, WABuilt 1986 · S/N 46-8608060N100HDLong Trace LLC · Madison, WIBuilt 1985 · S/N 46-8608003N100HSAir Works Ltd · Wilmington, DES/N E-3506N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019N100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113N100LKKoebele Thomas R · Cape May, NJBuilt 1977 · S/N CE-686N100LWN100lw LLC · Hickory, NCBuilt 1980 · S/N 32-8006091N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186N100NAInternational Air Services Inc Trustee · Carson City, NVS/N 32R-8013093N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526N100PSG & C Property Hc LLC · San Francisco, CABuilt 1987 · S/N CE1140N100QBShutt Ryan T · Eden, NYBuilt 1979 · S/N R18201185N100RBIngraham Donald S · New Bern, NCBuilt 1991 · S/N CE-1586N100RESchooler Jordan Benjamin · Hummelstown, PABuilt 1981 · S/N CE-987N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900N100WDEveryday Medicine LLC · Nicholasville, KYBuilt 1982 · S/N 32-8224008N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116N100WSQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1202N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249N100XPHeath Darrell L · Houston, TXBuilt 1991 · S/N CE-1564N100YVPalmy LLC · Lander, WYBuilt 1991 · S/N 243194N1010ARussell Jerald Trustee · Pampa, TXBuilt 1988 · S/N 24-3079N1010GHyde Kinder · Montgomery, ALBuilt 1989 · S/N 24-3098N1011NBlue Skies Aircraft LLC · Zephyrhills, FLBuilt 1970 · S/N 17259525N1013USiry Stanley A · Burke, VAS/N 24-3101N10143Fatdog LLC · Voorhees, NJBuilt 1981 · S/N 24-1107N1014TInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201650N1014UStubblefield Daniel R · Lake Havasu City, AZS/N 24-3106
Back to AD 85-23-07