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.

N5538UAircraft Sales LLC · Caledonia, MIBuilt 1969 · S/N 28-26260 N55390Davis Hunter · Winters, TXBuilt 1973 · S/N 28-7310134 N55392Fast Aircraft Aerowork Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedBuilt 1973 · S/N 28-7325391 N55397Stephens Ryan L · Gardner, ILBuilt 1973 · S/N 28-7305374 N55398Three Wire LLC · Portland, ORBuilt 1981 · S/N 17275174 N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945 N5539FAeronautical Technical Service Inc · Collierville, TNBuilt 1968 · S/N 28-24938 N5539JCarr Paul · Ottumwa, IAS/N 32-1000 N5539QJostad Leo D · Bottineau, NDBuilt 1965 · S/N 2958 N5539TPattison Aero Inc · Henderson, NVS/N R18201889 N5539UDickey Blaine K · Marion, ARBuilt 1969 · S/N 28-26261 N553APAviation Paradise LLC · Homestead, FLBuilt 1980 · S/N 17274554 N553BBJpm Flying Service LLC · Marine, ILBuilt 2017 · S/N 2014 N553BCCarlson Robert A · Red Wing, MNBuilt 2001 · S/N 2171 N553CBravo Air LLC · Frisco, TXBuilt 1991 · S/N 270105 N553DCCain T&T LLC · Kalispell, MTBuilt 2006 · S/N 27014C N553FLWalters Rande L Sr · Lock Haven, PABuilt 1971 · S/N 28-7125392 N553HCHotel Charlie LLC · Dallas, TXBuilt 2004 · S/N T18208287 N553KMRieder Kenneth J · Cincinnati, OHBuilt 2004 · S/N 81553 N553MBBickling Melvin T · Johnstown, COBuilt 2011 · S/N 91457 N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072 N553PGAnderson Adam Z · Bay City, MIBuilt 2005 · S/N 2318 N553PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842090 N553RVLittmann Daniel M · Broken Arrow, OKBuilt 2018 · S/N 74536 N553SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881342 N553SFSmith Nancy R · Duluth, MNBuilt 1966 · S/N 247 N553TCHawksley LLC · Bozeman, MTBuilt 2004 · S/N T20608487 N553TPOakland Flyers LLC · Oakland, CABuilt 1975 · S/N 28-7690105 N554Valiair Lc Trustee · Casper, WYS/N 1232 N55401Keesling Roger · Starkville, MSBuilt 1973 · S/N 28-7325405 N55402Gleason Scot · Hayden, IDBuilt 1973 · S/N 28-7325395 N55404Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17275175 N55407Yeager Bradley William · New Market, ALBuilt 1973 · S/N 28-7305377 N5540JLesser Antilles Corp Trustee · Wilmington, DEBuilt 1968 · S/N 32-1003 N5540KTymczyszyn William R · Torrance, CABuilt 1978 · S/N 394-78 N5540UEvans Thomas Patrick · Hollow Rock, TNBuilt 1969 · S/N 28-26262 N5540WAir-Crete Constructions Inc · Lake Elmo, MNBuilt 1962 · S/N 28-631 N55414Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 34-7350212 N55416Cox David S · Elizabethtown, KYBuilt 1973 · S/N 28-7325397 N55419Kinneberg Russell · Plymouth, MNBuilt 1973 · S/N 28-7305380 N5541MDistrict School Board Of Pasco County · Land O Lakes, FLFirst renewal noticeBuilt 1967 · S/N 127 N5541URegistered aircraftS/N 28-26263 N5541WKauffman Duane N · Sarasota, FLBuilt 1962 · S/N 28-632 N55420M A R S Aircraft Leasing LLC · Williamsburg, VABuilt 1981 · S/N 17275177 N55421Burton Tucker · Moberly, MOBuilt 1973 · S/N 28-7305381 N55422Boardman Thomas M · Greenwich, NYS/N 17275178 N55423Prescott Flying Club Inc · South Saint Paul, MNBuilt 1973 · S/N 28R-7335231 N55424Delgado LLC · Brandon, VTS/N 1228 N55428Flight Gear Aviation LLC · Pickerington, OHBuilt 1973 · S/N 28-7325399 N5542FColtman Graham E · Colleyville, TXBuilt 1968 · S/N 28-24941

Back to AD 87-10-06 R1