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.

N214AALewis University · Romeoville, ILS/N 28-4735N214ACRicard Carter J · Albany, MNBuilt 2000 · S/N 1305-2000N214BPHolmes Aviation Inc · Webster, FLBuilt 2000 · S/N 3257156N214BWKansas Farm & Ranch Inc · Seneca, KSBuilt 1994 · S/N 1202-94N214CMeister Curtis E · Plover, WIBuilt 1998 · S/N 1430N214CALester Don · Campton, NHBuilt 1974 · S/N 28R-7435281N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78N214DXDixon Craig M · La Grande, ORBuilt 2013 · S/N 91863N214EDWoods Johnny I · Hendersonville, TNBuilt 1980 · S/N 44-8195007N214ERLima-001 LLC · Muscatine, IAS/N 17263480N214FAGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281214N214GPPietsch Warren A · Minot, NDBuilt 1994 · S/N Z1A-0016N214GSStephens Mark · Cullman, ALBuilt 1972 · S/N 28-7205138N214GTAcba Inc Trustee · Wilmington, DEBuilt 2003 · S/N 2214N214HRSchaetzel Paul · New Meadows, IDBuilt 2025 · S/N 345N214HSDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1975 · S/N 27-7654014N214JADer Aviation LLC · Dover, TNS/N 3122N214JC214 Mooney LLC · Boca Raton, FLBuilt 1978 · S/N 24-0706N214JDMilngavie LLC · Plano, TXBuilt 2006 · S/N 20416N214JNFox-1 Drafting & Design Inc · Eagan, MNBuilt 1966 · S/N 30-1130N214JPTop Flight Leasing LLC · Frankfort, ILBuilt 1994 · S/N 3213083N214LE3 Weens LLC · Hoschton, GABuilt 2004 · S/N 18281416N214LHRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2005 · S/N 494-2005N214LMHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995053N214LPKrasa Paul W · Yorktown, VAFirst renewal noticeBuilt 1999 · S/N 214KRN214MHShadow Ventures LLC · Chesapeake, VAS/N T20608214N214MKMargheritis Alex F Trustee · Saugus, CABuilt 2007 · S/N 81855N214MMDunlap Lloyd A · Brighton, MIBuilt 1998 · S/N 335A-320-95N214NYCabco Enterprises LLC · Springdale, ARS/N 899N214PTNewkirk Peter C · Ellison Bay, WIBuilt 1990 · S/N 2039N214RLlano Charles · Lakeland, FLBuilt 1977 · S/N 32R7780522N214RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 28-7690440N214RBS And S 1165 Investments LLC · Wimberley, TXBuilt 1992 · S/N 2114N214RRReiff Robert P · Fort Atkinson, WIBuilt 2008 · S/N 2646N214SANeagle Jason S · Elizabethtown, KYS/N 28-7415482N214SHSiu Ena · Reno, NVBuilt 1963 · S/N E189N214TJVector Aeromedical Services LLC · Smithfield, NCBuilt 1979 · S/N R18201275N214XUXu Guihong · Tucson, AZBuilt 2010 · S/N 91634N214YRutigliano Peter J · Harrington Park, NJS/N MB1N21500Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 44-7995055N2150AAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-1862N2150BGreen Head Flight Services LLC · Bemidji, MNBuilt 1979 · S/N 32R-7987031N2150ELeuer Nicholas J · Emmetsburg, IABuilt 1978 · S/N 17271170N2150FShoreline Aviation Inc · Marshfield, MABuilt 1978 · S/N 28-7916186N2150JKing Mark A · Nolensville, TNBuilt 1978 · S/N 28-7911064N2150KCarey David John II · Mccall, IDBuilt 2003 · S/N T20608407N2150PWoodard Mark A · Hookstown, PABuilt 1956 · S/N 23-752N2150RChalkley Benjamin G · North Liberty, IABuilt 1969 · S/N 28-5471N2150SN2150s LLC · Charlotte, NCBuilt 1962 · S/N SP43N2150TBecker Brian C · Fort Dodge, IABuilt 1971 · S/N 28-7105165
Back to AD 87-10-06 R1