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.

N64LAHanner Investments LLC · Appling, GAS/N TH-978 N64LLReagan Ronald J · Litchfield Park, AZBuilt 2005 · S/N L2K-240 N64LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N TH-1749 N64MROne Mike Romeo Leasing LLC · Las Vegas, NVBuilt 2003 · S/N 0724 N64PHConklin Diana J · Kirksville, MOBuilt 1964 · S/N D-7496 N64PKTom Eaton Consulting LLC · West Sacramento, CABuilt 1964 · S/N D-7526 N64RESanocki Erika D · Phoenix, AZBuilt 1964 · S/N D-7670 N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169 N64VBTamworth Aviation LLC · Allen, TXBuilt 1973 · S/N TH-305 N64VTBonanza Aviation LLC · San Antonio, TXBuilt 1964 · S/N D-7640 N64WFAeromedical LLC · Lake In The Hills, ILBuilt 2013 · S/N E-3986 N64WRAlesia Holdings LLC · Beaumont, TXBuilt 2001 · S/N TH-1981 N64ZLewis Timothy W · Thousand Palms, CABuilt 1976 · S/N E-918 N6500Standard Equipment Leasing And Sales LLC · Wilmington, DEBuilt 1967 · S/N TE-500 N6500BAndrews Aviation LLC · Spartanburg, SCBuilt 2002 · S/N 40043 N6500GConsultant Services LLC · Stillwater, MNBuilt 2004 · S/N 42045 N6500LApsis Aviation LLC · Kentfield, CABuilt 2001 · S/N 40027 N6500VBlue Marble Aviation LLC · Center Valley, PABuilt 2003 · S/N 42033 N6501MByrne William J · Davis, CABuilt 2001 · S/N 40023 N6501UMoses Hunter K · Georgetown, TXBuilt 2004 · S/N 42040 N6501XFisher John P · Surprise, AZBuilt 1960 · S/N 57501 N6501YLively Charters Inc · Summerland Key, FLBuilt 1981 · S/N 21064412 N6501ZJ&M Aviation Enterprises LLC · Greendale, WIBuilt 2003 · S/N 42007 N6502ABelair Two LLC · Lancaster, PABuilt 2004 · S/N 42048 N6502XFalcon Way Partners LLC · East Helena, MTBuilt 2004 · S/N 42039 N65031Miller Lewis W · Setauket, NYBuilt 2004 · S/N 42060 N65035Vimco Aviation LLC · El Paso, TXBuilt 2004 · S/N 42052 N6503CPotts Phillip G · Chattanooga, TNBuilt 2003 · S/N 42015 N6503TRussell Construction Co · Douglas, WYBuilt 2002 · S/N 40039 N65042Blueventure LLC · Morganton, NCBuilt 2004 · S/N 42042 N6504DAirmart Aircraft Holdings Inc · Oak Ridge, NCS/N 42035 N6504EDietrich Robert R · Elizabeth, COBuilt 1980 · S/N 18504051 N6504KQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 40062 N6504XMarc Pauls · Charlotte, NCBuilt 2004 · S/N 42056 N6505CLancair Leasing LLC · Greensboro, NCBuilt 2003 · S/N 40066 N6505LTheriot Conchita F · Anderson, SCBuilt 2001 · S/N 40033 N6505N3c3 Aviation Inc · Dania Beach, FLBuilt 1979 · S/N 21063075 N6505VElg Air LLC · Birmingham, ALS/N 42053 N6505ZJames Bryan C · Fredericksburg, TXBuilt 2004 · S/N 42044 N6506VHarper Dreams LLC · New Smyrna Beach, FLBuilt 1976 · S/N 21061633 N6506ZAf Auto Group · San Jose, CABuilt 1981 · S/N U20606301 N6507VBrown Steven K · Tucson, AZBuilt 1982 · S/N EA-309 N6508ALynch John Z · Elon, NCBuilt 2004 · S/N 42038 N6508BTechnology Farm Inc · Tewksbury, MABuilt 2002 · S/N 40053 N6508FDi Ioia Mickey · Glen Mills, PABuilt 2004 · S/N 42061 N6508VBest John K · Cave Creek, AZBuilt 1982 · S/N CE-1008 N65093Seaman Michael V · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 21061844 N65099Aguirre-Y-Luker Grant C · Santa Fe, NMBuilt 2003 · S/N 40075 N6509GMehling Robert C · Hardin, MTS/N 18801202 N6509ZQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 42020

Back to AD 86-13-04 R3