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.

N87565Jerrys Kids Aviation LLC · Wilmington, DEBuilt 1967 · S/N D-8490 N8756QTriple 2 LLC · Burlington, COBuilt 1976 · S/N U20603509 N8758QBerge Christian · Mccall, IDBuilt 1976 · S/N U20603511 N8758ZBellows Paul F · Vancouver, WABuilt 1968 · S/N P206-0558 N8759ZHelin Bruce A Trustee · Flagstaff, AZBuilt 1968 · S/N P206-0559 N875DBDbco LLC · Greenwood Village, COBuilt 1980 · S/N TH-1135 N875PLBenvenuti Darel · Newport Beach, CABuilt 1965 · S/N CD-875 N875TMw Leasing Inc · Redlands, CABuilt 1965 · S/N D-7837 N8760QCarcioppolo Joseph A · Auburn Twp, OHS/N 18503768 N8761ZHaag Walter G · Fall City, WABuilt 1968 · S/N P206-0561 N8763QArtic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1976 · S/N U20603516 N876PMGeddie Steven Gwynn · College Station, TXBuilt 1976 · S/N E-961 N876R76r Holdings LLC · Rockport, TXBuilt 1978 · S/N 21062844 N876THighrider LLC · Humble, TXBuilt 1965 · S/N D-7753 N8775ZB&B Auto Body LLC · Terreton, IDS/N P206-0575 N8776QRichardson Thomas R · Valleyford, WABuilt 1979 · S/N 18503771 N8777XN8777x LLC · Dodge City, KSBuilt 2004 · S/N 1011 N8779VCockrell Tyler J · Clovis, NMBuilt 1970 · S/N 30316 N877CInternational Air Services Inc Trustee · Carson City, NVBuilt 2003 · S/N 0445 N877CAHausman Benjamin · Merritt Island, FLBuilt 1994 · S/N TH-1727 N877CDCharlie Bravo LLC · Lubbock, TXBuilt 2002 · S/N 0327 N877JBOg Flights LLC · Dover, DEBuilt 1980 · S/N 421C0877 N877JL8-Ball Aviation LLC · Southampton, MABuilt 2007 · S/N E-3804 N877TSpecialty Paving Inc · Lincoln, CABuilt 2001 · S/N E-3381 N8781ZHogue Marc · Tempe, AZBuilt 1969 · S/N P206-0581 N8783VDunbar Stephen E Trustee · Broken Arrow, OKBuilt 1971 · S/N 30361 N8783ZAdventure Aircraft And Equipment LLC · Chelan, WABuilt 1969 · S/N P206-0583 N8784VSwanson Steven V · Saint Marys, GABuilt 1971 · S/N 31017 N8785ZRegistration Pending · Connell, WARegistration pendingBuilt 1976 · S/N 18502920 N8786ZNordstrom Hans P · Wasilla, AKBuilt 1976 · S/N 18502921 N8787Q2fly Safety LLC Trustee · Azle, TXBuilt 1976 · S/N U20603539 N8787YStanyan Holdings LLC · Portland, ORBuilt 2005 · S/N 1589 N8787ZKing Farm Partnership · Mccrory, ARBuilt 1969 · S/N P206-0587 N8788QKochert Timothy B · Anchorage, AKBuilt 1975 · S/N U20602730 N8788UIzard Ryan S · Nacogdoches, TXS/N 17252693 N8788VMitchell Robert D · Blackwell, OKS/N 30323 N8789BBearcat Aviation LLC · Joplin, MOBuilt 1980 · S/N 414A0605 N8789ZParrott Charles F · Saugus, MAFirst renewal noticeBuilt 1969 · S/N P206-0589 N878BBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N TH-1710 N878CAKag Aviation LLC · Mc Carley, MSBuilt 1994 · S/N TH-1728 N878DMFly North 421 LLC · Helena, MTBuilt 1977 · S/N 421C-0413 N878PAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1488 N878VMJames Vincent M · Reading, PABuilt 2003 · S/N 0551 N878WMortgage And General Investment Corp · Big Bear Lake, CABuilt 2002 · S/N E-3459 N8792KRegistration Pending · Waco, TXRegistration pendingBuilt 1980 · S/N 340A0985 N8792ZPerkovich Brian T · Oneida, WIBuilt 1969 · S/N P206-0592 N8794ZJones Petroleum Co Inc · Jackson, GAS/N P206-0594 N8795QWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N U20603547 N8795ZNeuschaefer George H · White Hills, AZBuilt 1969 · S/N P206-0595 N8796QSpangler Robert E · Anchorage, AKBuilt 1976 · S/N U20603548

Back to AD 86-13-04 R3