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.

N606EAdvantage Data Systems Inc · Zionsville, INBuilt 2017 · S/N 41078 N606EAOakmere Leasing LLC · Norton Shores, MIBuilt 1979 · S/N 28-7916477 N606ERHansen Justin L · St George, UTS/N MB-397 N606HSMyers Kenneth K · Rangely, COBuilt 2003 · S/N 118 N606NTGimli Son LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1972 · S/N 653 N606PRReichman Paul · Cornwall, NYBuilt 2016 · S/N 41624 N606RFFitts Robert D · Independence, ORBuilt 2025 · S/N 1 N606RVSuper D LLC · Nunn, COBuilt 2016 · S/N 22851 N606STStruck Jeffrey · Orange City, FLBuilt 2008 · S/N 70606 N606TTTotusek Torger · La Palma, CABuilt 1985 · S/N 274 N606WLarson Bernard J · Mt Vernon, WABuilt 1965 · S/N 3172 N6070CShepard Gregory W · Fort Myers, FLBuilt 1979 · S/N 61P06787963319 N6070LPloski Greg · Prospect, CTFirst renewal noticeBuilt 1972 · S/N AA5-0170 N6070NKnott Donnie W · Milan, TNBuilt 1968 · S/N M-1164 N6070PParcell Charles W · La Canada Flt, CABuilt 1959 · S/N 24-1166 N6070QOdenbach Eric J · Eureka, SDBuilt 1966 · S/N 3328 N6070WHocking Christopher J · Hinckley, MNBuilt 1964 · S/N 28-20082 N60717Southern Comfort Horizons LLC · Naples, FLBuilt 1979 · S/N 61P06927963329 N6071DRiffle Thane G · Addy, WABuilt 1956 · S/N 22-4725 N6071PKohler Thomas M · Brant Beach, NJS/N 24-1167 N6071QHaven Hospitatlity LLC · San Marino, CABuilt 1965 · S/N 900 N6071WAbbott Joseph D · Chippewa Falls, WIBuilt 1964 · S/N 28-20083 N6071ZJones Wayne A · Miami, FLBuilt 2001 · S/N 20041 N60728Valiair Limited Company Trustee · Casper, WYBuilt 1979 · S/N 61P07007963335 N6072LLawrence Blake C · Monument, ORBuilt 1972 · S/N AA5-0172 N6072NDilecce Joseph · Sarasota, FLBuilt 1969 · S/N M-1209 N6072QTorres Mendoza Gonzalo · Rancho Cucamonga, CABuilt 1965 · S/N 901 N6072WHillman Maritime Services LLC · Lafayette, LABuilt 1964 · S/N 28-20085 N60733Rentner Judith E · Bigfork, MTS/N 18-3366 N6073AIjet LLC · Clarence Center, NYS/N 61P07017963336 N6073DDetrick Louis F · Eighty Four, PABuilt 1956 · S/N 22-4727 N6073LKottke Benjamin P · Central Point, ORBuilt 1972 · S/N AA5-0173 N6073NRozinka Jay C · River Falls, WIBuilt 1968 · S/N M-1166 N6073PBradshaw James L · Lenoir, NCBuilt 1959 · S/N 24-1169 N6074NParlog Roy H · Irwin, PABuilt 1968 · S/N M-1167 N6074PBerlingen Michael W · Oregon City, ORBuilt 1959 · S/N 24-1170 N6074QMiranda Edward G · Prescott Valley, AZBuilt 1965 · S/N 3253 N6074VBabb Bradley E · Enid, OKBuilt 1946 · S/N 2304 N6074WRegistration Pending · Los Angeles, CARegistration pendingBuilt 1964 · S/N 28-20087 N6075LChandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 0716 N6075PMoore Leslie D · Raymore, MOBuilt 1959 · S/N 24-1171 N6075VLister Cameron M · Loxley, ALBuilt 1958 · S/N 62057 N6075WVolk Alyssa M · Jordan, MNBuilt 1964 · S/N 28-20088 N6075ZModular Aviation LLC · Saratoga Springs, UTS/N 61P07188063347 N6076DPinnow Andrew W · Cheshire, CTBuilt 1956 · S/N 22-4730 N6076GColbert Farms Inc · Davenport, WAS/N 15071576 N6076MRomano Victor J Jr · Wasilla, AKBuilt 1996 · S/N 1306 N6076WBlyseth Brent A · Germantown, TNS/N 28-20089 N6077CBossey Joseph M · San Diego, CABuilt 1987 · S/N 5119 N6077DPargman Curtis A · Big Lake, MNBuilt 1957 · S/N 22-4731

Back to AD 87-10-06 R1