OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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.

N12HTRanieri Paul A · Palatine, ILBuilt 2012 · S/N 5044N12HUVintage Flyers LLC · The Villages, FLBuilt 1997 · S/N 1345N12HYRegistration Pending · Nephi, UTRegistration pendingBuilt 1999 · S/N 1448N12HZBaldauf Ryan L · Spencerville, OHBuilt 1976 · S/N 17266707N12JLGiber Kristofor D · Manvel, TXBuilt 1961 · S/N 27-404N12JXAc Holdings II Inc · Lewes, DEBuilt 1981 · S/N 025N12KBWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261915N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80N12KWAllied Moulded Products Inc · Bryan, OHBuilt 2000 · S/N 4636255N12LGLapiair LLC · Vergennes, VTBuilt 1998 · S/N 20418N12LMHaney Andrew J · Mt Morris, PAS/N 1001N12LPBlewett John Thomas Jr · Springfield, GABuilt 1998 · S/N 21056CN12LTBaker William A · Lincolnton, NCBuilt 1972 · S/N 406N12LVR2b2 Enterprises Lllp · Weldon Spring, MOBuilt 1975 · S/N 61-0238-099N12LZConlon Joseph F · Gainesville, FLBuilt 2011 · S/N LZ001N12MFitzpatrick H Mike · Cleveland, GABuilt 2010 · S/N 60548N12MBHarrison Hayden F · Mckean, PAS/N 1948N12MJCruiseair Aviation Inc · Ramona, CABuilt 1972 · S/N 17261299N12MPMarcus Robert L · Dallas, TXBuilt 1963 · S/N 30-284N12MVKarduck Craig · Morgan, UTS/N 3671N12NMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2006 · S/N 0036AKN12PShalun Lukas A · Germantown, TNBuilt 1977 · S/N 001N12PKDuncan Aviation Inc · Lincoln, NEBuilt 2000 · S/N 2103N12PNRegistration Pending · Maitland, MORegistration pendingBuilt 1998 · S/N 1243-98N12PUMeyer Daniel B · Redding, CABuilt 1998 · S/N 008N12PXMvs Air LLC · Kalispell, MTS/N 61P-0524-220N12PZA5 Flight Club LLC · Saint Cloud, FLBuilt 1974 · S/N AA5-0622N12QRWilson Koby D · Southside, ARBuilt 2000 · S/N 2121N12QWAll Aviation LLC · Tucson, AZBuilt 1984 · S/N 5053N12RDoll John M · Austin, TXBuilt 1976 · S/N 0744N12RDFlying Colors Airparts Inc · Leesburg, FLBuilt 1958 · S/N 24-368N12REWilliams Jeffrey · Georgetown, INBuilt 1982 · S/N EPPLETT-0001N12RZZapsky Richard M Jr · Houtzdale, PABuilt 2000 · S/N 5585N12SDStevens Sam D · Isola, MSBuilt 1973 · S/N 1376N12SFToller Rick L · Crescent City, FLBuilt 1977 · S/N 814N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412N12SVHarmacinski Larry Trustee · Punta Gorda, FLBuilt 1947 · S/N 418N12TASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 22-6319N12TCCb22 Holdings LLC · Price, UTBuilt 1977 · S/N 28-7790417N12TESchwigen Justin R · Alton, ILBuilt 1998 · S/N 1440N12TLLoofbourrow Travis S · Houston, TXBuilt 1968 · S/N 60N12TQWyoming Aeroflight LLC · Laramie, WYBuilt 1994 · S/N 1270N12TRRegistered aircraftBuilt 1991 · S/N 10053N12TZJ H O Enterprises Inc · Carol Stream, ILS/N 61-0259-101N12VRCulver Lane M · Laceys Spring, ALBuilt 1988 · S/N 10058CN12WAIoe Aviation LLC · Kirkland, WABuilt 1994 · S/N 21712N12WKGallagher Glenn C · Lakeland, FLBuilt 1984 · S/N 5811N12WPSpradlin Flying Service Inc · Petersburg, TXS/N 1013N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206N12XGCommander Aviation LLC · Williamsburg, VABuilt 1977 · S/N 14237
Back to AD 87-10-06 R1