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.

N9644JLeckliter Michael A · Murrieta, CABuilt 1966 · S/N 28-3808N9644KLuck Aviation LLC · Glen Allen, VABuilt 1976 · S/N 28R-7635252N9644MBurley Joseph D · Fayetteville, GABuilt 1966 · S/N 670221N9644QSkyhawks Inc · Chippewa Falls, WIBuilt 1975 · S/N 17265728N9645DDarryn Allyson R · Las Cruces, NMBuilt 1959 · S/N 22-6559N9645HSantiago Diana L · Juana Diaz, PRBuilt 1975 · S/N 17266292N9645JLuxury Vacations Inc · Scottsdale, AZBuilt 1966 · S/N 28-3809N9645VOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1974 · S/N 17264425N9646BN9646b LLC · Wilmington, DEBuilt 1981 · S/N 172RG0942N9646DFerrell Alan B · Arlington, OHBuilt 1959 · S/N 22-6560N9646KHumphreys Garfield · Port Saint Lucie, FLBuilt 1976 · S/N 32R-7680236N9646RB-Dog Aviation LLC · Grand Junction, COS/N TD-345N9646WOgier Gerard Paul · Hampton, NHBuilt 1967 · S/N 28-23105N9647BLakewood Investments LLC · Victorville, CAS/N 172RG0943N9647DSutton Neal · Ashby, NEBuilt 1959 · S/N 22-6561N9647MSoaring Eagle Flying Club · Midland, MIBuilt 1966 · S/N 670224N9647QKaeni Law Group Inc · Santa Ana, CABuilt 1975 · S/N 17265731N9647UWilhite Randall D · Plainville, MABuilt 1975 · S/N AA5A-0013N9647WAirplanes Plus Inc · Marathon, FLBuilt 1967 · S/N 28-23106N9648BBarker David C · Lumberton, NCBuilt 2012 · S/N 838N9648HSaunders Larry F · Sulphur Springs, ARBuilt 1975 · S/N 17266294N9648MN9648m LLC · Louisville, KYBuilt 1967 · S/N 670225N9648QGreen Bay Flying Club Inc · Krakow, WIBuilt 1975 · S/N 17265732N9648VGrove Kaylene · San Diego, CABuilt 1974 · S/N 17264428N9648WMccullough Dwayne D · Onancock, VABuilt 1967 · S/N 28-23107N96493Smtm Holdings Inc · Wilmington, DES/N 17276080N9649BGoebel Christian E · Luray, VABuilt 1981 · S/N 172RG0945N9649DUlrich Kenneth B Jr · Kingwood, TXBuilt 1959 · S/N 22-6563N9649JRegistration Pending · Springboro, OHRegistration pendingBuilt 1967 · S/N 28-3876N9649PHarris Hill Soaring Corp · Horseheads, NYBuilt 1975 · S/N 25-7556008N9649VLagorce Victor X · Owasso, OKBuilt 1974 · S/N 17264429N9649WWard Travis E · Tucson, AZBuilt 1967 · S/N 28-23109N964AAFlorida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 17271084N964ABSmith Craig W · Horton, MIBuilt 1983 · S/N GEM-2N964AC63 Victor LLC · Fremont, OHBuilt 1999 · S/N 20608073N964ALMay Robert E · Payson, AZBuilt 1996 · S/N 263N964DJMcculloch Randall L · Romulus, NYBuilt 1999 · S/N 0594N964GRRene Gary W · Alamo, TXBuilt 2010 · S/N 0005N964HLGraham Huber L · Gulf Breeze, FLBuilt 2001 · S/N 1N964JCIceman Air LLC · Stafford, VABuilt 1976 · S/N 22-1355N964LAHarriman Robert M Sr · Grand Isle, VTBuilt 1964 · S/N 286N964LJAir Mercury LLC · New Rochelle, NYBuilt 1997 · S/N 3246082N964MMModular Aviation LLC · Saratoga Springs, UTBuilt 1978 · S/N 27-7854132N964PLBlue Sky Industries LLC · Wilmington, DEBuilt 2004 · S/N 80315N964RNNoyes Randall L · Henderson, NVBuilt 1981 · S/N 964N964SEGray Luke Francis · San Bruno, CABuilt 2004 · S/N 964-2004N964SHI1 Aviation LLC · Wilmington, DEBuilt 2005 · S/N 3941N964SMMatta Sam · Houston, TXBuilt 1996 · S/N 2235N964SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8176N964TEBedard Robert L · Bolivar, OHBuilt 2005 · S/N 10243
Back to AD 87-10-06 R1