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.

N6547CJrp Management LLC · Williams, AZBuilt 1980 · S/N 21063915 N6547NHart Anthony · Promise City, IABuilt 1978 · S/N 21063103 N6548CRobinetti Newbeard LLC · Stratford, CABuilt 1982 · S/N E-2051 N654AJVintage Wings Aircraft LLC · Center Point, INBuilt 1964 · S/N D-7474 N654CDCharlie Delta Aviation LLC · Sheridan, WYBuilt 2005 · S/N 1733 N654DEDill Brice R · Glendale, AZBuilt 1978 · S/N 310R1428 N654SCLewis Aviation Inc · Wilmington, DEBuilt 1988 · S/N CE-1257 N6551CChurch Thomas · Lenoir, NCS/N D-10402 N6551VNorthstar Bonanza LLC · Flagstaff, AZFirst renewal noticeBuilt 1967 · S/N CE-185 N6552VSatellite Airways Ltd · Pella, IABuilt 1967 · S/N D-8623 N6553V44hw LLC · Shreveport, LABuilt 1967 · S/N D-8625 N6553YCenturion Aero LLC · Coos Bay, ORBuilt 1981 · S/N 21064434 N6554VXwgnfc LLC · Horsham, PABuilt 1967 · S/N D-8624 N6555YMild Charles F · Harlingen, TXBuilt 1981 · S/N 21064436 N6557BFangio Mark · Mckinney, TXBuilt 1978 · S/N 21062786 N6559Watson Charles R Jr · Austin, TXBuilt 1980 · S/N CE-877 N6559VDodson International Parts Inc · Rantoul, KSBuilt 1969 · S/N 30248 N655BCritical Craft Technologies LLC · Charlotte Hall, MDBuilt 1948 · S/N D-1654 N655CDCrh Services Inc · Shreveport, LABuilt 2004 · S/N 0916 N655DDWarren Jason J · Silverdale, WABuilt 1988 · S/N CE-1263 N655TWilliams Terry J · Owasso, OKBuilt 1972 · S/N E-328 N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014 N6562YKp Builders Inc · Pittsburgh, PABuilt 1981 · S/N 21064440 N6564DSan Antonio Prop Slingers LLC · La Vernia, TXBuilt 1982 · S/N E-2048 N6566VRiley Shawn P · Saint Paul, MNBuilt 1969 · S/N 30252 N6567YMoeller Gerhard Walter · Goshen, OHBuilt 1981 · S/N 21064442 N6568XBarnes Inc · Lewiston, IDBuilt 1980 · S/N U20605950 N656CDAec Ally Equipment Company Inc · Murray, UTBuilt 2004 · S/N 1006 N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111 N656SCSummers Concrete Contracting Inc · Hahira, GABuilt 2009 · S/N TH-2269 N656TWAnderson Leif Knut · Sidney, MTBuilt 2005 · S/N 1331 N6570VHildreth Jay · Wamego, KSBuilt 1969 · S/N 30257 N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444 N6573EZxtair LLC · Janesville, MNS/N 1942SV N6573KGta Air Inc · Addison, TXBuilt 1983 · S/N TH-1369 N6574VHandke Robert C · Atchison, KSBuilt 1969 · S/N 30250 N6576SBeech Aviators LLC · Brookings, SDBuilt 1976 · S/N E-803 N6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020 N6580XSouthwest Aerial Survey LLC · Carlsbad, CABuilt 1983 · S/N EA-341 N6582Phoenix Aviation LLC · Bonaire, GABuilt 1976 · S/N 340A0125 N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191 N6582QHuss M Stephen M D · Decatur, ILBuilt 1983 · S/N E-2068 N6582VMonroe Robert Sean · Oceanside, CABuilt 1969 · S/N 30256 N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958 N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112 N6585XNorthbay Consulting LLC · Bellevue, WABuilt 1983 · S/N EA-340 N6586EJordan Sidney G · Wasilla, AKBuilt 1980 · S/N 18504057 N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800 N65873Carpenter Steve · Batesville, ARBuilt 1983 · S/N EA-342 N6588VIsom Stephen R · Eagle, COBuilt 1970 · S/N 30265

Back to AD 86-13-04 R3