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.

N57PWRegistration Pending · Moorcroft, WYRegistration pendingBuilt 2000 · S/N P01099N57REChapman John · San Antonio, TXBuilt 2009 · S/N 60468N57RKN57rk LLC · Rockwell, NCBuilt 2004 · S/N 3232016N57RROdette David N · Thief River Falls, MNBuilt 1968 · S/N 28R-30467N57RTChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N ME-172N57RVEshleman Mark O · Land O Lakes, FLBuilt 1998 · S/N 22199N57SDNuza Philip A · Sidney, MEBuilt 2001 · S/N 6043N57SPNuzzo Christian · Starkville, MSBuilt 1975 · S/N 2051N57TFHighernet LLC · Antioch, CABuilt 1998 · S/N 27-0257N57TPSheradin Daniel R · Roxboro, NCBuilt 2022 · S/N 001N57TVPitts Holdings LLC · Jacksonville, FLBuilt 1982 · S/N 2263N57VBKlingebiel Kurt · Leonardtown, MDBuilt 1985 · S/N 17276476N57VHMiller David · Independence, MOBuilt 1979 · S/N 700N57WTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1990 · S/N 1056N57WBBig Red Spring LLC · Fernandina Beach, FLBuilt 1983 · S/N 32R-8329034N57WCLong Dennis L · Blackshear, GABuilt 1977 · S/N 1N57WDDarling William H · Sprakers, NYBuilt 1966 · S/N 28-3395N57WHMoon Richard B · Arizona City, AZBuilt 1976 · S/N 17267069N57WS4031 Aviation Inc · Bemidji, MNS/N 18-5463N57XPBobcat Aviation LLC · Pretty Prairie, KSBuilt 2009 · S/N 3RX-130N57YSDavis Jeffery S · Oregon City, ORBuilt 1998 · S/N GA-0063N580Aeroblayze Aviation LLC · Norman, OKBuilt 1972 · S/N 43-72N5800Hayes Dennis P · Des Moines, IABuilt 2005 · S/N 233N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880N5802LHarrold Michael C · Hamilton, MTBuilt 1971 · S/N AA5-0002N5802PHass Morgan E · Lyons, ORBuilt 1959 · S/N 24-882N5803EIrwin Donald L · Emporia, KSBuilt 1978 · S/N 17271938N5803PLaskey Steven W · Littleton, COBuilt 1959 · S/N 24-883N5803WClifford William M · North East, MDBuilt 1964 · S/N 28-1877N5804FNoonday Sun LLC · Kensington, OHBuilt 1976 · S/N 28-7790134N5804LAa Horizons LLC · League City, TXBuilt 1971 · S/N AA5-0004N5804NAvioneta LLC · Atwater, OHBuilt 1978 · S/N 14372N5804PWitt Aviation LLC · Naperville, ILBuilt 1959 · S/N 24-884N5804QMoffet Jeffrey C · Lawrence, KSS/N 3111N5804USand Piper Air LLC · Endicott, NYBuilt 1970 · S/N 28-26632N5804VNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716204N5804WBard Nathan R · Carlisle, PABuilt 1964 · S/N 28-1895N5805DEasley Clarence E · Pleasanton, KSS/N 22-4480N5805PGrace Family Fellowship Inc · Oklahoma City, OKBuilt 1959 · S/N 24-885N5805QLam Michael · Bellaire, TXBuilt 1965 · S/N 768N5805UFoxtrot Three Flying Services LLC · Henderson, NVBuilt 1970 · S/N 28-26633N5805WPackett Robert E · Silverdale, WAFirst renewal noticeBuilt 1964 · S/N 28-1897N5806LSutphin Christoper F · Darlington, SCS/N AA5-0006N5806VJolliff Herbert H · Independence, ORBuilt 1977 · S/N 28-7716205N5806YDan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1965 · S/N 27-2939N58079Byrne David P · Ojai, CAS/N 24-1638N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887N5807QDavis Kevin B · Bellmawr, NJBuilt 1965 · S/N 769N5808LChristensen Donald R · Anchorage, AKBuilt 1971 · S/N AA5-0008N5808QSaathoff Michael A · Stockton, MOBuilt 1965 · S/N 3113
Back to AD 87-10-06 R1