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.

N914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLBuilt 1967 · S/N 27-3769N914DSaker Air LLC · Charlotte, NCBuilt 2000 · S/N 1104N914DPGonzalez Ramiro · Lancaster, OHBuilt 1966 · S/N 24-4633N914ETrettin Anthony K · Mason City, IABuilt 2005 · S/N 70599N914GPRoy Dino · Saginaw, TXBuilt 1966 · S/N MA-124N914HMeadows Mark A · Mooresville, INBuilt 1999 · S/N 21325N914HMMiesler Hans U · Penrose, COBuilt 1971 · S/N 1N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646N914JBSwartz Eric C Trustee · Aptos, CABuilt 2000 · S/N 18280786N914JDAis Wings LLC · Grand Rapids, MIBuilt 1972 · S/N 17261296N914JWWright John T · Jacksonville, FLBuilt 1975 · S/N 419N914LALindbergh Aviation Inc · Hampton, NHBuilt 1981 · S/N 32R8129108N914MGHolman Larry E · Cleveland, GABuilt 1970 · S/N 32-1281N914NCCarter Aviation LLC · Tucson, AZBuilt 2013 · S/N T20609113N914PLand-O-Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1983 · S/N 28-8311015N914PACoco Aircraft Inc · Merritt Island, FLBuilt 1999 · S/N 2843303N914RFHbe Aviation LLC · Salem, VABuilt 1980 · S/N 32R-8029054N914RLNichols Charles C · Hanford, CABuilt 2004 · S/N 18281399N914RRMartinez Jeff L · Lewistown, MTS/N 17264508N914SCole Thomas Ed · White Settlement, TXS/N 106N914SWSilver Express Co DBA · Miami, FLBuilt 1999 · S/N 172S8160N914THanley Stuart · Hollywood, FLBuilt 1960 · S/N TD-347N914TCSpeed Racer LLC · Port Orange, FLBuilt 2013 · S/N 087N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N9150DFitzgerald Larry · Fairbanks, AKBuilt 1958 · S/N 18-6540N9150GCampbell Ken · Lincoln, CABuilt 1991 · S/N 27-0115N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N9150VUrness John · Oakland, CABuilt 1969 · S/N 690038N9150WMcmullin Chad D · Roosevelt, UTS/N 28-10777N9150YTyler Transport LLC · Troy, ALBuilt 1985 · S/N 32R-8513009N9150ZV T Whitlock Inc · Lake City, SCBuilt 1991 · S/N 27-0116N91516Johnsoon Miller · Huntsville, ALBuilt 1991 · S/N 27-0120N91518Hatfield Timothy E · Parowan, UTBuilt 1996 · S/N 3121N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090N9151VNeret Michael G · Sugarland, TXBuilt 1969 · S/N 690031N9151XHawkins Aviation LLC · Gilbertsville, KYS/N 27-0149N9151YRegistration Pending · South Jordan, UTRegistration pendingBuilt 1995 · S/N 24-3366N9152KHangar 9 Inc · Aberdeen, SDBuilt 1976 · S/N 28-7615179N9152SHomer Mark · Grosse Ile, MIBuilt 1975 · S/N MC-399N9152WTeal Water Investments LLC · Blanco, TXBuilt 1966 · S/N 28-10784N9153CPax Enterprises Inc · Allen, TXBuilt 1978 · S/N R18200425N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N9153JRamer Kristina · Ruskin, FLBuilt 1988 · S/N 2811021N9153PA&E Aviation LLC · Ruston, LABuilt 1966 · S/N 24-4639N9153SB Squared Inc · Bedford, NHBuilt 1976 · S/N MC-400N9153VRegistered aircraftBuilt 1969 · S/N 690027N9153YAkn Inc · Crystal, MNBuilt 1991 · S/N 27-0125
Back to AD 87-10-06 R1