Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047 N6147VBerry David A · Santa Cruz, CABuilt 1961 · S/N D-7791 N61487Vspeed LLC · Saint Paul, MNBuilt 1983 · S/N D-10396 N6148FWorsham Eric S · La Porte, TXS/N 21059048 N614CTailwinds LLC · Warsaw, INBuilt 2002 · S/N 0411 N614CQC & H Aviation LLC · Lagrange, GABuilt 1977 · S/N 310R1239 N614CY614 Charlie Yankee Lc · Ames, IABuilt 2004 · S/N 1050 N614LGleason Gregory C · Ennis, MTBuilt 1977 · S/N D-10055 N614RCMacisaac Richard · Northampton, MABuilt 2002 · S/N 0249 N614RZRasmusson Timothy · Elma, NYBuilt 2004 · S/N 0897 N614TMHallman David M Jr · Erie, PABuilt 1974 · S/N E-567 N6150CNantucket Aviation LLC · Plymouth, MNBuilt 1981 · S/N E-1960 N61516Zaikof Bay LLC · Jackson, WYBuilt 1981 · S/N 18504223 N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001 N6151RPath Barney H DBA · Claremont, CABuilt 1965 · S/N T210-0051 N6151UMccall John A · Grapeland, TXBuilt 1985 · S/N 21064914 N6151YBulloch Troy P · Cedar City, UTS/N 21064269 N61522Zipay Michael A · Willow, AKS/N 18504226 N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724 N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052 N6152UAmerican Frontier LLC · Wilmington, DEBuilt 2008 · S/N TH-2252 N6152XPakan Dwight John · Charlotte, NCBuilt 1978 · S/N 310R1302 N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696 N6153ZJaars Inc · Waxhaw, NCBuilt 1981 · S/N U20606162 N6154NDouer Isaac R · Miami, FLBuilt 1978 · S/N 21062925 N6154SSchreiber Stephen · Windermere, FLBuilt 2014 · S/N L2K-303 N6154WBramlett LLC · Carrollton, TXBuilt 2003 · S/N 0632 N61556Clark William J · Kuna, IDBuilt 1981 · S/N 18504230 N6155RPlane + Simple LLC · Salt Lake City, UTBuilt 1965 · S/N T210-0055 N6155YAl & Zal Corp · Wilmington, DEBuilt 1981 · S/N 21064271 N61562Airhound Inc · Indian Lake, NYBuilt 1981 · S/N 18504231 N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006 N6158RMahany John C · Yucca Valley, CABuilt 1965 · S/N T210-0058 N61599Freebird Aviation LLC · Eagle, IDBuilt 1974 · S/N U20602350 N6159ULaw Office Of Vincent G Rieger · Kalispell, MTBuilt 1985 · S/N 21064927 N615AGAmala Andrew · Hollywood, MDBuilt 1973 · S/N CE-470 N615BBBmu22 LLC · Lancaster, OHBuilt 2005 · S/N 1682 N615LMPerrett Construction Ltd · Valentine, NEBuilt 2002 · S/N 0412 N615MPMorning Star Transportation Inc · Dardanelle, ARBuilt 2001 · S/N 40017 N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615 N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260 N615PWCardiac LLC · Amarillo, TXBuilt 2004 · S/N 1157 N615PXKempton Robert · Tampa, FLBuilt 2006 · S/N 29-0418 N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427 N616U S D A Forest Service Fepp · Columbia, SCBuilt 1967 · S/N U206-0849 N61609Eriksen Bjorn A · Polson, MTBuilt 1981 · S/N 18504235 N6160NRj Capital LLC · Mustang, OKBuilt 1978 · S/N 21062931 N61616Wolstenholme Ralph E · Westfield, PABuilt 1981 · S/N 18504237 N6161FBeach Bums Air LLC · Martin, GABuilt 1968 · S/N 21059061 N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932

Back to AD 86-13-04 R3