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.

N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372T N2082WRegistered aircraftBuilt 1965 · S/N D-8008 N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904 N2083SDave Schmauderer · Woodland, CAS/N 21061049 N20849Tradewind Ventures LLC · Evans, GABuilt 1999 · S/N 30-0017 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009 N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N2085YLima Romeo Kilo Golf Lp · Worthington, INBuilt 1973 · S/N 18502151 N2086LMortensen Daniel R Trustee · Newhall, CABuilt 1976 · S/N CE-658 N2088USimpson Equipment Leasing LLC · Hays, KSBuilt 1982 · S/N U20606610 N20896Mccullar Miles Glenn · Hagerman, NMBuilt 1977 · S/N E-1163 N2089WBaron 2089w LLC · Jupiter, FLBuilt 1966 · S/N TE-60 N208LHOtt Grosvenor LLC · Dillingham, AKBuilt 1974 · S/N U20602642 N208PGrateful Center Transportation LLC · Lutz, FLBuilt 1991 · S/N TH-1626 N208SSSeldom Seen Aviation Northwest Inc · Stevensville, MTBuilt 1974 · S/N 18502452 N208TMustang Sally LLC · Bullhead City, AZFirst renewal noticeBuilt 1974 · S/N E-572 N208VBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 421B0866 N208WPCassidy Ryan H · Seattle, WABuilt 1980 · S/N U20605836 N208WSMoore David P · Chugiak, AKBuilt 1969 · S/N NAV-4-2528 N2090LBarnes Seth M · Hot Springs, ARS/N D-10074 N2091LLippert John C · Danville, VABuilt 1976 · S/N E-967 N2092SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1975 · S/N 21061058 N2092WEarthcirc08 LLC · Chagrin Falls, OHBuilt 1966 · S/N D-8044 N2093WKliewer Silas M · Ulm, MTBuilt 1966 · S/N D-8039 N20969Kembel Robert D · Saint Ignatius, MTBuilt 1976 · S/N 18503049 N2098WHolland Greg R · Irvine, CABuilt 1966 · S/N CE-9 N209DCDelaware Corp · Topping, VABuilt 1979 · S/N 414A0229 N209HWWep Ent LLC · Graford, TXBuilt 2004 · S/N 29-0330 N209KSSchneider Kerry · Alpine, WYS/N P21000560 N209MPInks Allen W · Boerne, TXBuilt 1988 · S/N CE-1285 N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371 N20DJBeach Bum Airways LLC · Saint Petersburg, FLBuilt 1966 · S/N TE-191 N20DMLowe Aviation Co · Macon, GABuilt 1973 · S/N 27-7305066 N20DPErvin Eric · La Follette, TNBuilt 1988 · S/N 4608140 N20EZRegistration Pending · Bigfork, MTRegistration pendingBuilt 1969 · S/N 310P0078 N20HMMullett Peter C · Carbondale, COBuilt 1975 · S/N E-750 N20JNGana Trucking & Excavating Inc · Martell, NES/N 340A0050 N20MLong David M · Schaumburg, ILBuilt 1983 · S/N BG-204 N20MCOpie Aviation Services LLC · Nashville, NCBuilt 1979 · S/N 25-0067 N20MWStriebel David J · Dayton, OHBuilt 1975 · S/N 421B0918 N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411 N20VKEvans Jeffrey L · Mansfield, LABuilt 1977 · S/N 310R0978 N20VPGoby Air LLC · Howell, MIBuilt 2014 · S/N E-4025 N20WFLofton Christopher L · Harlingen, TXBuilt 1976 · S/N 310R0684 N2100EKovach David A Md · Greenwood, INBuilt 1971 · S/N E-290 N2102FOlson Tim O · Saint Onge, SDBuilt 1964 · S/N U206-0302 N2103SSan Diego Flight Corp · San Diego, CABuilt 1975 · S/N 21061067 N2104FBrown Steven R · Soldotna, AKBuilt 1964 · S/N U206-0304

Back to AD 86-13-04 R3