Registered aircraft · 18,495

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.

N951DSDerrick Schmidt Enterprises Inc · Vinita, OKBuilt 1978 · S/N TH-898 N951LEChi Walter D · Aspen, COS/N 320F-0029 N951MMChambers Wilbert Wayne Jr · Burlington, NCBuilt 1974 · S/N D-9707 N951POncourse LLC · Miami, FLBuilt 2001 · S/N TH-2015 N951PBHare Aviation LLC · Haddam, CTBuilt 2005 · S/N 1449 N951PCLeadair LLC · Brattleboro, VTBuilt 2005 · S/N 29-0374 N9520QKazuko Holdings LLC · Kalispell, MTS/N CE-21 N9521ESchmidt Sanford V · Kingsville, MDBuilt 1976 · S/N 76-30832 N9523QBoughner Michael L · Westminster, COBuilt 1966 · S/N CE-23 N9525EKern George R · Topeka, KSBuilt 1976 · S/N 76-30839 N9527MWhitetail LLC · Anchorage, AKBuilt 1981 · S/N 20700701 N9528YHunt William R · Tucson, AZBuilt 1981 · S/N 21064538 N9529CSilver Lining Carpet Care & Restoration LLC · Tallahassee, FLS/N T30300185 N952CF A Phoenix LLC · Eldorado, WIBuilt 2002 · S/N 0422 N952CBCentral Business Jets Inc · Burnsville, MNBuilt 1979 · S/N 21063729 N952WBIcarus Aviation LLC · Mountain Brk, ALBuilt 2008 · S/N TH-2213 N9531BLash Trucking LLC · Goleta, CABuilt 1979 · S/N 21063175 N9531ECook Larry L · Dongola, ILBuilt 1975 · S/N 75-30793 N9533HPatnode Jeffrey W · Lewistown, MTBuilt 1977 · S/N 18503446 N9533YN9533y Corp Trustee · Wilmington, DEBuilt 1981 · S/N 21064539 N9534EBorscht Inc · Valley View, PABuilt 1975 · S/N 76-30803 N9535YSpectra Q LLC · Las Vegas, NVBuilt 1981 · S/N 21064540 N953DMMainline Services Co · Wilmington, DEBuilt 1976 · S/N 340A0205 N953DSShows Douglas · Seabrook, TXBuilt 1983 · S/N TJ-443 N953STBoone Keith · Cabot, ARBuilt 1976 · S/N 21061155 N9540GSchwend Brian · Forsyth, MTBuilt 1974 · S/N 18801520 N9541GAllen Charles Mark · Puryear, TNBuilt 1974 · S/N 18801521 N9548GMeyer Bros Ag LLC · Algona, IABuilt 1974 · S/N 18801526T N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749 N954DTDatesman Miles E · Pittsburgh, PABuilt 2005 · S/N 29-0387 N954LBMccollom Perry C · Saint Louis, MOBuilt 2010 · S/N E-3938 N954MCBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 421B0891 N954PWWeckbacher Paul J Jr · Inverness, FLBuilt 1981 · S/N U20606288 N954REvans William Heath · Groveton, TXBuilt 1981 · S/N CE-954 N954SSacco Jeffrey L Trustee · Punta Gorda, FLBuilt 2009 · S/N TH-2271 N9551ECrosby David J · Potomac, MDBuilt 1977 · S/N 77-30853 N9552GJesse Shipman Farms LLC · Honey Grove, TXBuilt 1974 · S/N 18801529T N9553EWatson Glenn G · Lancaster, CABuilt 1976 · S/N 76-30830 N9553QTaylor Matt · Tahoka, TXBuilt 1966 · S/N D-8189 N9554EHosteller Samuel R · Plains, MTBuilt 1977 · S/N 78-30862 N9554GMorse Donald · Priest Lake, IDBuilt 1972 · S/N U20601754 N9555GMccormick Eugene C · Tyler, ALBuilt 1974 · S/N 18801531 N9555QRegistration Pending · Cottonwood, AZRegistration pendingBuilt 1966 · S/N D-8193 N9556JS & D Spraying Service Inc · Panhandle, TXBuilt 1981 · S/N 18803821 N9556ZIsland Aircraft LLC · Anchorage, AKBuilt 1918 · S/N U20606543 N9558ERussell John Kenneth Sr · Graford, TXBuilt 1975 · S/N 76-30798 N955BRBuffalo River Aviation LLC · Bentonville, ARBuilt 1972 · S/N TH-230 N955CWWheeler Howard L II · Fort Myers, FLBuilt 1974 · S/N 310R0084 N955DJGray John Michael · Saint Petersburg, FLBuilt 1967 · S/N TE-300 N955GBBioventures Leasing Corporation LLC · Brookhaven, GABuilt 1999 · S/N E-3286

Back to AD 86-13-04 R3