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.

N9935RUsda Aphis Ppq · Edinburg, TXBuilt 1986 · S/N U20606988 N9939ZRiver Front Akn LLC · Anchorage, AKBuilt 1983 · S/N U20606758 N993ESRegistered aircraftBuilt 1969 · S/N TE-748 N993JTGood Life Aviation LLC · San Tan Valley, AZBuilt 2006 · S/N 29-0447 N993MDBoyd Aviation LLC · Lakeville, MNBuilt 1984 · S/N CE1029 N993MWAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2020 · S/N TH-2535 N993PPCc Bar Ranch LLC · Texarkana, TXBuilt 1975 · S/N U20602634 N993QTangen Arthur · Albuquerque, NMBuilt 1961 · S/N D-6873 N993SRThree S Ranch Inc · Blanca, COBuilt 1980 · S/N P21000477 N993TBeyond Approach LLC · Brighton, COBuilt 1964 · S/N D-7414 N9940FHarvey Air LLC · Arlington, TNBuilt 1972 · S/N 340-0173 N9941MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1982 · S/N 20700748 N9941ZParagon Air Group · Fort Worth, TXBuilt 1983 · S/N U20606760 N9942MAlaska Aircraft Leasing LLC · Silverdale, WAFirst renewal noticeBuilt 1982 · S/N 20700756 N9943MBristol Bay Air Service Inc · Dillingham, AKBuilt 1982 · S/N 20700757 N9943ZState Of Maine Department Of Agriculture · Old Town, MEBuilt 1983 · S/N U20606762 N9944RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1986 · S/N U20606993 N9946MGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700588 N9947GArthur Aviation LLC · Arthur, NDBuilt 1971 · S/N 18800747 N9948MGrant Aviation Inc · Anchorage, AKBuilt 1982 · S/N 20700759 N9948ZAlien Invaders LLC · Medina, WABuilt 1983 · S/N U20606767 N994CDNavair LLC · Mount Vernon, OHBuilt 1979 · S/N 21063312 N994MZMahz Air LLC · Laredo, TXBuilt 1985 · S/N 421C1803 N994NZFrakes Stephen A · Frisco, COBuilt 1978 · S/N 21062470 N994PMAlpha Dogs Aviation LLC · Powell, OHS/N 1386 N994RJAirline Pilot Careers LLC · Champlin, MNBuilt 1977 · S/N 18503260 N994SBB Squared LLC · Russellville, ARBuilt 2005 · S/N 1364 N994WYInternational Air Services Inc Trustee · Carson City, NVS/N TE-1001 N9952ZMcdougall Enterprises LLC · Tualatin, ORBuilt 1983 · S/N U20606771 N9953CEjj Group Inc · New York, NYBuilt 1983 · S/N T30300241 N9953MAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1980 · S/N 20700656 N9955JMehling Robert C · Hardin, MTS/N T18803884T N9955MBell Jason W · Mount Pleasant, TXBuilt 1989 · S/N TH-1575 N9956MRyan Air Inc · Anchorage, AKBuilt 1983 · S/N 20700763 N9957MArctic Aviation Leasing LLC · Anchorage, AKBuilt 1983 · S/N 20700764 N9957RScg Leasing LLC · Owensboro, KYBuilt 1986 · S/N U20606999 N9959RRusyniak Anthony J · Syracuse, NYBuilt 1986 · S/N U20607000 N995EGEagle Group USA Inc · Howell, MIBuilt 1980 · S/N EA-90 N995GPQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 310R1328 N995KClemmer Norman L · Green Lane, PABuilt 1995 · S/N 29-0040 N9960NBoemer Steven E · El Cajon, CABuilt 1982 · S/N 18504377 N9962MFox Aircraft LLC · Bethel, AKS/N 20700765 N9963YN9963y LLC · Provo, UTBuilt 1982 · S/N 21064649 N9964YGreenspun Mark H · Washington, DCBuilt 1982 · S/N 21064650 N9967RBravan Aviation · Fort Lauderdale, FLBuilt 1986 · S/N U20607005 N9968GPetecraft Aviation Services Inc · Plains, GABuilt 1971 · S/N 18800768 N9968JBoening Bros Dusting & Spraying Scv · Floresville, TXBuilt 1981 · S/N T18803897T N9968PFlax Brian J · Germantown, TNBuilt 1997 · S/N E-3109 N996AKSierra Sky Aviation LLC · Kalispell, MTBuilt 1970 · S/N U20601519 N996CDGrace Flying Service Inc · Saint Francis, KSBuilt 2005 · S/N 1499

Back to AD 86-13-04 R3