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.

N958MLLazarowicz Michael J · Port Clinton, OHBuilt 2017 · S/N 81849N958SBVictor Foxtrot LLC · Scott City, KSBuilt 1979 · S/N R18200954N958TENewman Robert · Groton, NYBuilt 2004 · S/N 10237N958VTMetcalfe Robert B · Flint Hill, VABuilt 2021 · S/N 116N9590MRegistration Pending · Paynesville, MNRegistration pendingBuilt 1966 · S/N 670167N9591Freelance Enterprise LLC · Clayton, WABuilt 1973 · S/N 122N9591BSmith Justin T · Marshfield, WIBuilt 1981 · S/N 172RG0904N9591CLoera Arnold · Dillingham, AKBuilt 1989 · S/N 1077N9591JLea Brenda A · Merriam, KSBuilt 1966 · S/N 28-3730N9591MPeakland Properties Inc · Charleston, TNS/N 670168N9591USmolek Michael A · Saint Marys City, MDBuilt 1976 · S/N AA5A-0091N9592DJohnson Jeremiah W · Tulsa, OKS/N 22-6499N9592LHausknecht Brian · Corpus Christi, TXBuilt 1974 · S/N AA5-0592N9592UN9592u LLC · Versailles, KYBuilt 1976 · S/N AA5A-0092N9592WDreamcatcher Aviation LLC · Austin, TXS/N 28-23040N9593BBehnke Christopher H · SiegburgBuilt 1981 · S/N 172RG0906N9593HSaliba Bahig Nadim · Scottsdale, AZBuilt 1975 · S/N 17266252N9593JPhillips Raymond A Jr · Vestal, NYBuilt 1966 · S/N 28-3732N9593KShoham Aviation LLC · Richmond, TXBuilt 1976 · S/N 28-7625185N9593LPeters Larry L · Sheffield, IABuilt 1974 · S/N AA5-0593N9593VWeaver Robert D · Petersburg, WVBuilt 1974 · S/N 17264395N9594CPassino Nicholas J · Latham, NYBuilt 1978 · S/N 28R-7837209N9594HEagle Sky Patrol Inc · Deadwood, SDS/N 17266253N9594JJensen Enterprises LLC · Iola, KSBuilt 1966 · S/N 28-3740N9594SRuiz Santiago · Jupiter, FLBuilt 1965 · S/N 41N9594UWilliams Jason R · Drums, PABuilt 1976 · S/N AA5A-0094N9594WMiddlecoast Air LLC · Grand Rapids, MIBuilt 1967 · S/N 28-23044N9595DSchlosser Joseph V · Rockford, MNBuilt 1958 · S/N 22-6502N9595JMuller Chester E · Hayward, CABuilt 1966 · S/N 28-3741N9595MRegistered aircraftBuilt 1966 · S/N 670172N9595TWorden James L · Tucson, AZBuilt 1989 · S/N 1072N9595UGrumman Squadron LLC · Prattville, ALBuilt 1976 · S/N AA5A-0095N95962Forst Richard A · Sitka, AKBuilt 1989 · S/N 1093N95965Colvin Kurt W · San Luis Obispo, CABuilt 1989 · S/N 1094N9596DRoss Jack H · Portland, ORBuilt 1958 · S/N 22-6504N9596EKingaire LLC · Panama City, FLS/N 77-32-171N9596HCorby Brenda K · Oak View, CABuilt 1976 · S/N 17266255N9596JAstraeos Aviation LLC · Salisbury, NCBuilt 1966 · S/N 28-3742N9596LPriebe John F · Troy, OHBuilt 1974 · S/N AA5-0596N9596UOlds Jack R DBA · Madison, INBuilt 1976 · S/N AA5A-0096N9596WFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N 28-23046N9597BCanada Gary Jr · Coy, ARS/N 1095N9597JWingswat LLC · Placentia, CABuilt 1966 · S/N 28-3743N9597LRowe Richard D · Waterloo, INBuilt 1974 · S/N AA5-0597N9597MRegistered aircraftBuilt 1966 · S/N 670174N9597VSkelton Jeffrey · Sioux Falls, SDBuilt 1974 · S/N 17264399N9597ZHanson James A · Bandon, ORS/N 1098N9598BIpsen Michael · Kenosha, WIBuilt 1981 · S/N 172RG0909N9598DDurden William L · Tallahassee, FLBuilt 1958 · S/N 22-6506N9598HImsar LLC · Springville, UTBuilt 1975 · S/N 17266256
Back to AD 87-10-06 R1