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

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.

N47764Wl Aviation LLC · Olney, MDBuilt 1977 · S/N 32R-7880021 N47767Capps Clinton Wyatt · Navasota, TXBuilt 1977 · S/N 28-7816132 N47768Registered aircraftBuilt 1977 · S/N 28-7816133 N4776EAlpha One Aviation LLC · Dunedin, FLBuilt 1978 · S/N 17271641 N4776JKimbrough Paul E · Millcreek, UTBuilt 1967 · S/N MB-221 N4776LHitt John C · Plano, TXBuilt 1967 · S/N 28-4110 N4776THigh Planes Air Service · Bismarck, NDBuilt 1981 · S/N R18201762 N47773Walo Barry F · Cresson, TXBuilt 1977 · S/N 28-7890137 N4777JHowell Michael A · Parsons, KSBuilt 1967 · S/N MB-224 N4777LRoss Charles B · Anchorage, AKBuilt 1967 · S/N 28-4111 N4777SN4777s LLC · Ault, COBuilt 1980 · S/N R18201424 N4778EClemmons Flyers LLC · Green Cove Springs, FLS/N 17271643 N4778LGarrett Russell K · Hazen, NDS/N 28-4112 N4779TAmerican Aerial Patrol LLC · Saint Amant, LABuilt 1981 · S/N R18201764 N477ALSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 17701285 N477AMSpicher Samuel C Jr · Groveland, FLBuilt 2021 · S/N 28020017 N477BCSchellhorn Frederick · 55296 Harxheim MaiBuilt 1994 · S/N 27-0184 N477BGParker Dennis A · Charlevoix, MIBuilt 1977 · S/N AA5A0364 N477CHCsi Flight Services LLC · Mcminnville, ORBuilt 2004 · S/N 3729 N477DMiller Clark · Grapevine, TXBuilt 1977 · S/N 32R-7780367 N477DCChildress David W · Coldwater, MSBuilt 2007 · S/N 70717 N477DKPhilippi Ranches Inc · Hermiston, ORS/N 2160 N477LLLima Lima LLC · Lander, WYBuilt 1968 · S/N 18-8755 N477LMStampley Michael C · Mount Pleasant, SCBuilt 1965 · S/N 643 N477LPTomchan LLC · Bostic, NCBuilt 2005 · S/N T18208477 N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030 N477MHGulf Flight Inc · Oldsmar, FLBuilt 1979 · S/N 70022 N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200 N477PSSilver Patrick F · Toney, ALBuilt 2016 · S/N 91796 N477RRadtke Jeffrey A · Norwalk, CTBuilt 2003 · S/N 3232006 N477RVVans Aircraft Inc · Aurora, ORBuilt 2004 · S/N 71702 N477SFAps Asset Management Inc · Mesa, AZBuilt 1999 · S/N 088 N477SPRegistration Pending · Leesburg, VARegistration pendingBuilt 2004 · S/N 71402 N477TPaetzold Benjamin T · Fort Worth, TXBuilt 1967 · S/N 670274 N4780APenn Flyers LLC · Greensburg, PABuilt 1956 · S/N 22-3931 N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645 N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228 N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115 N4780YPhiladelphia Glider Council · Hilltown, PABuilt 1968 · S/N 25-4548 N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134 N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136 N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231 N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116 N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139 N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140 N4782GSeguin Elliot · Rosamond, CABuilt 1968 · S/N 77 N4782POlson Allan K · Tarpon Springs, FLBuilt 1960 · S/N 27-338 N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030 N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204 N4783Haire Kenneth H · Star City, ARS/N 93

Back to AD 87-10-06 R1