Registered aircraft · 72,007

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056 N3486NRose Thomas Z · Santa Ana, CABuilt 1967 · S/N 680068 N3486RMorrissey David H · Queensbury, NYBuilt 1969 · S/N 28-5701 N3486WSteele Jackie L · London, KYBuilt 1966 · S/N 32-364 N3486XLaas Enterprises Inc · Warrens, WIBuilt 1966 · S/N 3423 N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058 N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059 N3487QIsrael Jonathan · Huntington Beach, CABuilt 1977 · S/N 28-7716159 N3487XKrzeminski Paul A · San Carlos, CABuilt 1966 · S/N 3424 N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064 N34888Double J3 Aviation LLC · West Palm Beach, FLS/N 17702066 N3488NValley Aviation LLC · Fargo, NDBuilt 1967 · S/N 680070 N3488WLiberty University School Of Aeronautics · Lynchburg, VABuilt 1966 · S/N 32-367 N3488ZBastian Richard L · Burns, WYBuilt 1960 · S/N 18-7325 N34894Whitney Ron · Indianapolis, INBuilt 1974 · S/N 17702070 N34896Kidron Flying Club Pll · Wooster, OHBuilt 1974 · S/N 17702071 N34897Loscheider Brian P · Cologne, MNBuilt 1974 · S/N 17702072 N3489KGfh LLC · Zillah, WABuilt 1967 · S/N 28-23582 N3489TBlue Skies Aviation LLC · Belfast, MEBuilt 1968 · S/N 17700789 N3489XHanson Jonathan · Palmer, AKS/N 1159 N348BPEks LLC · Lenoir City, TNBuilt 2001 · S/N 18077C N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564 N348CPHaddock Tracey P · Kingstree, SCBuilt 1998 · S/N 17280348 N348DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843841 N348JMMelby Jon D · Chandler, AZBuilt 1997 · S/N 4002 N348JWHupp Patrick · Gladstone, MOBuilt 2001 · S/N 01JW N348KEEllwood Luke D · Springboro, OHBuilt 1998 · S/N 001 N348MAWilson Ralph W Trustee · Mentor, OHBuilt 2002 · S/N 1337-2002 N348MBClay David L · Bryceville, FLS/N 1662 N348MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881418 N348PBAbu Trailers Inc · Dwight, NDBuilt 2011 · S/N 40978 N348PSTim Moyer Management LLC · Whitefish, MTBuilt 2005 · S/N 27-0348 N348PVVollheim Peter M · Nashua, NHBuilt 1984 · S/N 348 N348RPWright-Piros Ruth · Carlisle, IABuilt 1979 · S/N 32-7940186 N348RVBayani Amir · Roswell, GABuilt 2002 · S/N 81189 N348SAPutman James R Jr · Kernersville, NCBuilt 1974 · S/N 17702065 N348STDream Aircraft Inc · Zeeland, MIS/N 529 N348TCWilliams Ryan D · Panama City, FLBuilt 2004 · S/N 18281434 N34900Payne Richard L · Flint Hill, VABuilt 1974 · S/N 17702074 N34901Brannan Christopher L · Garberville, CAS/N 17702075 N34904Carolina Sky Aviation LLC · Charleston, SCBuilt 1974 · S/N 17702078 N34905Taylor Made Enterprises LLC · Mesa, AZBuilt 1974 · S/N 17702079 N34908Registered aircraftBuilt 1974 · S/N 17702082 N34909Thomes Gregory L · Maple Lake, MNBuilt 1974 · S/N 17702083 N3490NRegistration Pending · Prescott, AZRegistration pendingBuilt 1967 · S/N 680071 N34910Jackson Flight Associates Inc · Sherburn, MNBuilt 1974 · S/N 17702084 N34915Roberts David C · Sidney, IABuilt 1974 · S/N 17702088 N34916Denardo Stephen B · Cranston, RIBuilt 1974 · S/N 17702089 N34917Chester Zechariah L · Eau Claire, MIBuilt 1974 · S/N 17702090 N3491NArmstrong William · Scotts Valley, CABuilt 1967 · S/N 680072

Back to AD 87-10-06 R1