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.

N404CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881109 N404CHNorthwestern Michigan College · Traverse City, MIBuilt 1976 · S/N 27-7654191 N404DSDelaware State Universtiy · Dover, DEBuilt 1976 · S/N 28-7615141 N404GAEly Ag Services LLC · Sallisaw, OKBuilt 2005 · S/N 10953 N404JEMedia Stew LLC · Carson City, NVBuilt 1993 · S/N 724-93 N404MHCall One Inc · Clarinda, IABuilt 2018 · S/N 75-10615 N404NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010004 N404RBMyrehn Bruce D · Carmel, INBuilt 1972 · S/N AA5-0101 N404SDToms Aviation Inc · Addison, ILBuilt 2006 · S/N 11217 N404SEBaird Jonathan D · Saint Joseph, MIBuilt 1974 · S/N 28R-7435223 N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702 N404TWRobison Dave · Roberts, IDBuilt 1997 · S/N 1348 N404UXSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 28-5423 N404WBNew England Airlines Inc · Westerly, RIBuilt 1977 · S/N 564 N404XXInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N R18201624 N405Burklund Joel H · Minneapolis, MNBuilt 1996 · S/N 1340 N40506Dingler Larry G · Langtry, TXS/N 1753 N4050GSpellbound Inc · White Bear Lake, MNBuilt 1991 · S/N 1776 N4050NCrawford Reagan Matthew · Lumberton, TXBuilt 1968 · S/N 680026 N40510Yonika Richard J · Northbridge, MABuilt 1973 · S/N 27-7405241 N4051PEagle 64 LLC · Stuart, FLBuilt 1958 · S/N 23-1528 N4051WHenningsen Gregory Mark · Arvada, COBuilt 1966 · S/N 32-40071 N40520Goodman Larry D Trustee · Prineville, ORBuilt 1975 · S/N 18-7509121 N40522Khag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 27-7405255 N40523Gossett Owen L · Central Point, ORBuilt 1975 · S/N 18-7509123 N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002 N4052VBorror Eric F · Gerber, CABuilt 1956 · S/N 18-5218 N4052ZMetro Service Air · Fairbanks, AKBuilt 1963 · S/N 18-8054 N4053RDorsett Brandon · Buckeye, AZBuilt 1967 · S/N 32-40355 N4053TSky High Helicopters LLC · Camarillo, CABuilt 2018 · S/N 30045 N4053ZSpohnholz Randy K · Anchorage, AKBuilt 1963 · S/N 18-8056 N40549Agnew Mark W · Wasilla, AKBuilt 1969 · S/N 18-8865 N4054GWorks Mark S · Cincinnati, OHBuilt 2023 · S/N 30095 N4054XLongmire Vaughn H · Tampa, FLS/N 5154 N4054ZBiggs Craig P · Preston, IDBuilt 1963 · S/N 18-8059 N40552Peeler Jason B · Flooresville, TXS/N 18-7509126 N40557Legacy Aviation LLC · Tea, SDBuilt 1973 · S/N 27-7405297 N40558Hill Casey J · Anchorage, AKBuilt 1975 · S/N 18-7509127 N40559Frost Aviation Services Inc · Las Cruces, NMBuilt 1973 · S/N 27-7405300 N4055BViking Aviation LLC · York, NEBuilt 1974 · S/N 75-32-151 N4055KHarris William R Jr · Salisbury, CTBuilt 2020 · S/N 2611 N4055NKansara Sanjay · Coopersburg, PABuilt 2020 · S/N 2619 N4055RBroadhurst Eric Clark · Brookline, NHBuilt 1967 · S/N 32-40358 N4055WDiehl Frances M · Alamogordo, NMBuilt 1966 · S/N 32-40079 N4055XAtlas Air LLC · Salt Lake City, UTBuilt 1974 · S/N 5055C N4055ZMartin Lawrence M · Clam Gulch, AKS/N 18-8060 N40566Miller Stan · Skiatook, OKBuilt 1973 · S/N 27-7305188 N40569Harvey Sawyer N · Jaffrey, NHBuilt 1974 · S/N 27-7405310 N4056MBarfield Anthur F · Fairborn, OHBuilt 1991 · S/N 1793 N4056VHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2023 · S/N 30093

Back to AD 87-10-06 R1