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.

N422KAStewart Scott A · Anchorage, AKBuilt 1975 · S/N 18-7509009 N422KBKaempfer Melissa Jean · Lenoir City, TNBuilt 1999 · S/N 18280512 N422LBMckeever Gregory Allen · Holly Springs, NCFirst renewal noticeBuilt 1981 · S/N 32R-8113030 N422MCWendt Michael · Tecumseh, NEBuilt 1977 · S/N 32-7740088 N422NPGarvin Honi J Trustee · Monument, COBuilt 2007 · S/N 23103C N422RMMoore Aviation Inc · Beaver Falls, PAS/N 2843526 N422RVMachin Geoffrey C · Friday Harbor, WABuilt 1998 · S/N 21422 N422SHelfrick Jr Edward W · Elysburg, PABuilt 2006 · S/N 2059 N422SCAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30022 N422TTTravland Christopher L · Austin, TXBuilt 1978 · S/N R18200221 N422USParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020125 N422WBHbk LLC · Lynden, WABuilt 1977 · S/N 31-7752152 N422WCWilliams Wade M · Wasilla, AKBuilt 2020 · S/N 001 N422WFRoberts Wayne T · Spring Lake, MIBuilt 1946 · S/N 12-2520 N422WGWilliams Sara J · Kendallville, INBuilt 1980 · S/N 28-8016341 N422WHAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2000 · S/N 0795 N423Shafer Robert T · Grosse Ile, MIBuilt 1978 · S/N AA5B0986 N4230HHonolulu Helicopter Tours Inc · Honolulu, HIBuilt 2013 · S/N 2323 N4230JPleasant Valley Aviation Inc · Bellefonte, PABuilt 1966 · S/N 28-22579 N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130 N4230ZBishop Mike · Rifle, COBuilt 1966 · S/N 18-8456 N42312Swinehart Frank E · Lock Haven, PABuilt 1995 · S/N 773 N4231JBielusiak Stanley J · Dartmouth, MABuilt 1967 · S/N 28-22580 N4231RKearney Larry Neal · Graham, TXBuilt 1969 · S/N 32-40596 N42321Olson Richard Allen · Weatherford, TXBuilt 2018 · S/N 3275 N4232FSekel David A · San Diego, CABuilt 1976 · S/N 28-7725005 N4232HHupp Garrett · Sunbury, PABuilt 1978 · S/N 24-0671 N4232JN4232j LLC · Waialua, HIS/N 28-22581 N4232TDgap LLC · Niles, OHBuilt 1971 · S/N 28-7210005 N4233CFons William M · Oconomowoc, WIBuilt 1992 · S/N 3161 N4233QWoods John B · Anchorage, AKBuilt 1971 · S/N 17260133 N4233R33 Romeo Inc · Wilmington, DEBuilt 1969 · S/N 32-40598 N4233TSmith Michael L · Lakeland, FLBuilt 1982 · S/N 186 N4233ZThompson Lee B · Anchorage, AKBuilt 1966 · S/N 18-8459 N4234HKacprzak Dominik · Kingwood, TXBuilt 1978 · S/N 24-0673 N4234JHomerun Horizons LLC · Weatherford, TXBuilt 1967 · S/N 28-22585 N4234QFarr Everett L III · Bensalem, PABuilt 1971 · S/N 17260134 N4234TParsons Donald Jr · Crumpler, NCBuilt 1971 · S/N 28-7205109 N4234ZLueking Clyde F · Holdrege, NEBuilt 1966 · S/N 18-8460 N42358Bakker Margaret E Trustee · Petaluma, CABuilt 1974 · S/N 28-7425314 N4235HJunker Gregory G · Cincinnati, OHBuilt 1978 · S/N 24-0676 N4235JBarrett Kevin M · Pittsburg, TXBuilt 1967 · S/N 28-22586 N4235RWustman Charles Dryer · Westerly, RIBuilt 1999 · S/N 25033C N42361Lima 001 LLC · Muscatine, IABuilt 1974 · S/N 17264171 N42363Harrison Kent B · Grass Valley, CABuilt 1974 · S/N 28-7415389 N4236ZMinnehan Joseph T · Joplin, MTBuilt 1966 · S/N 18-8462 N4237JMoppert Stephen Kyler · Madison, MSS/N 28-22589 N4237TPeak 2 Peak Enterprises LLC · Sebring, FLS/N 28-7225101 N4237ZYorgason Ty C · Worland, WYS/N 18-8464 N42388Mccaan Jerome · Bethel, MEBuilt 2003 · S/N 27009C

Back to AD 87-10-06 R1