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.

N6140KHepner Glenn L · New Port Richey, FLBuilt 1980 · S/N 17274169N6140PBrake It LLC · Pensacola, FLBuilt 1959 · S/N 24-1241N6140WKing Donna K · Mount Pleasant, MIBuilt 1964 · S/N 28-20158N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353N6140ZConnecticut Soaring Association Inc · New London, CTS/N 25-164N61411Vincent Tarissa · Westminster, COS/N 1151N6141JRnt Air LLC · Mitchell, SDBuilt 1976 · S/N 28-7615312N6141PRs Agricultural Operations LLC · Dell City, TXS/N 24-1242N6141TMilligan David L · Fresno, CAFirst renewal noticeBuilt 1982 · S/N R18201918N6141VWright Lawrence D · West Chester, PABuilt 1965 · S/N TD-614N6141ZRotor And Wing · Tioga, NDBuilt 1960 · S/N 25-165N6142DManbeck Michael R · Summerville, SCBuilt 1957 · S/N 22-4786N6142PAllison Trent Van · Southlake, TXBuilt 1959 · S/N 24-1243N6142SKelly Robert D · Sheboygan, WIFirst renewal noticeBuilt 1965 · S/N 18-50N6142WBurns Robert J · Loxahatchee, FLBuilt 1964 · S/N 28-20160N6142XHurt Ronald L · Smithville, TNBuilt 1977 · S/N 17269169N61430Arias Aviation Inc · Wilmington, DEBuilt 1974 · S/N 31-7401242N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414N6143TWong Antonio L · Santa Rosa, CAS/N R18201919N61447Overton Tommy · Cumberland Gap, TNBuilt 1995 · S/N 0007N6144DCarter Tim R · Morgan, UTBuilt 1957 · S/N 22-4788N6144MBargabos Richard O · Peterboro, NYBuilt 1978 · S/N 7169CN6144NDunn Rick · Benton, ARS/N MB-415N6144VAir Flite Inc · Shawnee, OKBuilt 1996 · S/N 0037N6144WFiebelkorn Daniel S · Gregory, SDBuilt 1964 · S/N 28-20162N61455Hutcheson David Carl · Santa Rosa Beach, FLBuilt 2004 · S/N 18281363N61458Dls Holdings Inc · Lewes, DEBuilt 1995 · S/N 0008N6145DLindsey Christopher T · Nesbit, MSBuilt 1957 · S/N 22-4789N6145SPlaney Mcplane Face LLC · N Richlnd Hls, TXBuilt 1980 · S/N R18201625N6145VMarshall University · Huntington, WVBuilt 1996 · S/N 0045N6145WRegistered aircraftS/N 28-20163N61465Bishop Michael D · Pulaski, TNS/N 12-3189N6146PMount Up Aviation LLC · Kirbyville, MOS/N 24-1247N61470White Jerald W DBA · Jackson, TNBuilt 1974 · S/N 31-7401262N61474Harper Analeasa Leighan · Clarksville, TNBuilt 2004 · S/N 18281370N6147DRegistered aircraftBuilt 1957 · S/N 22-4792N6147EBuckley Michael J · Billings, MTBuilt 1995 · S/N S1707N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229N6147MSix One North LLC · Anchorage, AKBuilt 1978 · S/N 7185CN6147RBloom James F · Clay City, KYS/N 172RG0094N6147WLister Stephen J · Sherman, ILBuilt 1964 · S/N 28-20166N61486Johnson Gary R · Carthage, NYBuilt 1998 · S/N 0084N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230N6148JNorth Texas Flight Ventures LLC · Mckinney, TXBuilt 1976 · S/N 28-7615313N6148NAll-In-Aviation LLC · Paragould, ARBuilt 1969 · S/N M-1225N6148VChupp Aaron · Gallipolis, OHBuilt 1998 · S/N 0086N6148WAir Ventures Flying School LLC · Smithfield, RIBuilt 1964 · S/N 28-20167N61490Wings Of Hope Inc · Chesterfield, MOBuilt 1975 · S/N 31-7512004N61494Millican Marc J · Anchorage, AKS/N 18-5712N614973 Dudes 1 Plane LLC · Olympia, WABuilt 1976 · S/N 28-7625109
Back to AD 87-10-06 R1