OpenAirDocs.org
AD 87-18-06 R1

Registered aircraft · 6,238

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-18-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-18-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.

N621RHSchiffer Herbert · West Chester, PABuilt 1991 · S/N E-2654N62254Richard Nestor · Boise, IDS/N TJ-431N6231AEtzelmiller Arjay J · Lincoln, NEBuilt 1981 · S/N E-1983N6233GFlying Cardinals Aircraft Group Inc · Stow, MABuilt 1981 · S/N E-1984N6233XRdm Ventures LLC · Buckhead, GABuilt 1982 · S/N E-1988N6234ZBruce Bullock · West End, NCBuilt 1981 · S/N E-1985N62379Sullivans Island Aerospace LLC · Sullivans Island, SCBuilt 1982 · S/N E-2007N623MHBearden George F Jr · Weatherford, TXBuilt 1989 · S/N CE-1364N624DKFw Cielo LLC · Canton, OHBuilt 1976 · S/N D-9879N624TELenbob Aviation LLC · Southaven, MSS/N TH-1588N6254NCoil Construction Inc · Columbia, MOBuilt 1981 · S/N E-1989N6255BRogers Aeronautics LLC · Lake Barrington, ILBuilt 1981 · S/N E-1990N6255JAzimuth Aviation LLC · Mechanicsburg, PABuilt 1996 · S/N E-3019N625HWBsw Acceptance Inc · Muleshoe, TXBuilt 1993 · S/N TH-1694N625LMDsb Investments LLC · Dodge City, KSBuilt 1991 · S/N CE-1600N625MOverbeek Michael F · Holland, MIBuilt 1974 · S/N TH-434N625SGoldman Ryan · Cordova, TNBuilt 1972 · S/N TE-881N6261KGlasmon Inc · Nacogdoches, TXBuilt 1981 · S/N E-1993N6266NSai Flight Services Inc · Greer, SCBuilt 1982 · S/N E-2001N6267XWahlen Per · Newtown Square, PABuilt 1982 · S/N D-10391N626CRSmiles Aviation LLC · Kerrville, TXBuilt 1978 · S/N E-1367N626PRai Aviation LLC · Athens, GAS/N E-3552N6271RAir Jag LLC · Garden City, KSBuilt 1982 · S/N TH-1331N627AJJorfam Properties LLC · Dripping Springs, TXBuilt 1974 · S/N D-9583N627KCHorsehead LLC · Ada, MIBuilt 1990 · S/N CE-1480N6283NValiair Lc Trustee · Casper, WYBuilt 1982 · S/N E-2002N6284UBonanza Group LLC · Phoenix, AZBuilt 1982 · S/N E-2003N62854High Flight Connections LLC · Roanoke, INBuilt 1982 · S/N E-2008N6285NMoon Dipper Aviation LLC · Deerfield Beach, FLBuilt 1982 · S/N E-2005N6285XSpires William A · Columbus, GABuilt 1982 · S/N E-2006N628AKBaron Partners LLC · Bessemer, ALS/N TH-1614N628MDClarkton Aviation III LLC · Clarkton, MOBuilt 1992 · S/N TH-1662N628SECane John Paul · San Jose, CABuilt 2000 · S/N EA-655N6292ZBlv Aviation LLC · Columbus, INBuilt 1982 · S/N E-2010N6297LMccaskill Justin E · Montgomery, TXBuilt 1982 · S/N E-2012N6298URed Roadrunner LLC · Richmond, KYBuilt 1982 · S/N CE-995N6298XN111es Inc · Monticello, INS/N E-2013N6299XSouth Florida Exotics LLC · Missoula, MTBuilt 1982 · S/N E-2016N629BEWbme LLC · Warrenville, SCBuilt 1999 · S/N E-3287N629CJEssex Aircraft Management LLC · Randolph, NJS/N TH-2104N629EBRuff Cattle Co · Hanston, KSBuilt 1997 · S/N E-3085N629PGOrial Floyd · Evans, GABuilt 2004 · S/N E-3550N62AUFaust Richard J · Richmond, TXBuilt 1981 · S/N EA-247N62BBUp And Down Aviation LLC · Perry, GABuilt 1973 · S/N TH-328N62BJCapital Dental Management Inc · Dover, DEBuilt 1973 · S/N D-9414N62CVTessos Air Service Inc · Wilmington, DEBuilt 1987 · S/N TH-1523N62GMRankin Ty · Amarillo, TXBuilt 1980 · S/N E-1713N62JBHcb Media LLC · Los Angeles, CAS/N E-1160N62JRN62jr LLC · Lakeside, MTBuilt 1988 · S/N CE-1298N62LEMayfield Aviation LLC · Salem, UTBuilt 1977 · S/N E-1171
Back to AD 87-18-06 R1