Registered aircraft · 6,915

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:71-13-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1') 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:71-13-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
  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:71-13-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:71-13-01-R1')
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.

N204RSKenai Peninsula Air Transportation & Lodging LLC · Lake Havasu, AZBuilt 2011 · S/N T20609029 N204SCGyure Ronald J · Fort Worth, TXBuilt 1965 · S/N 27-2796 N204SJStuart M Davis Inc · Rice, WABuilt 1972 · S/N 32-7240097 N20506Lim Arnold · Walnut Creek, CABuilt 1997 · S/N 27-0238 N2054ZRp3 LLC · Boise, IDS/N T18208449 N2057PBullock Gary · Saint Regis, MTBuilt 2004 · S/N T18208227 N2059U5c Valley Aviation LLC · Sun Valley, IDS/N T20608701 N205APPappalardo Anthony · Vero Beach, FLBuilt 2000 · S/N 46-36250 N205SGWilliams Christopher · Wallingford, KYBuilt 2005 · S/N 3255041 N2061Ramos Sammy · San Juan, PRBuilt 2022 · S/N T20609710 N20617Mtnairpower LLC · Santa Barbara, CABuilt 2017 · S/N T20609522 N2062MJadma LLC · Helena, MTBuilt 1977 · S/N 32R-7880051 N2064FMicrowave Rental LLC · Beaufort, SCBuilt 2022 · S/N T20609687 N2064PPrivitt Bret · Hudson Oaks, TXBuilt 2023 · S/N T20609734 N206AGDesevarg Inc · Appleton, WIBuilt 2020 · S/N T20609618 N206AMLiu Ke · Millburn, NJBuilt 2003 · S/N T20608436 N206AZGrant Investments LLC · Bakersfield, CABuilt 2015 · S/N T20609176 N206BDBge Aviation LLC · Camden, ARBuilt 2018 · S/N T20609541 N206CCCharlie Charlie LLC · Wasilla, AKBuilt 2019 · S/N T20609574 N206CVC & C Transportation Inc · Benton, LABuilt 2000 · S/N T20608164 N206DKFly Waveboard Inc Trustee · Wilmington, DEBuilt 2009 · S/N T20608949 N206DTSchons Jeffrey · Pacific City, ORBuilt 2006 · S/N T20608662 N206DVBowman And Dehn Enterprises Inc · Georgetown, DEBuilt 2007 · S/N T20608724 N206DWAlaskan Start Aviation LLC · Midland, TXBuilt 1999 · S/N T20608145 N206DYMorgan Farms LLC · Nyssa, ORBuilt 2006 · S/N T20608684 N206EAAbrams Edward L · Roxbury, CTBuilt 2000 · S/N T20608186 N206EEHastings Ranch Vineyard · Paso Robles, CABuilt 2005 · S/N T20608505 N206EMHoopes Turf Farm Inc · Ulysses, PABuilt 2011 · S/N T20608995 N206GESheldon Graham · Bellevue, WABuilt 2018 · S/N T20609536 N206HMilestone Aviation LLC · Vail, COBuilt 2022 · S/N T20609684 N206HDBarry Adventure Travel Inc · Pagosa Springs, COBuilt 2018 · S/N T20609554 N206HGSeecat LLC · Palo Alto, CABuilt 2011 · S/N T20608994 N206HJRauch Peter · Austin, TXBuilt 2007 · S/N T20608713 N206HMDma Aviation Services LLC · Wilmington, DEBuilt 2021 · S/N T20609672 N206LWestern Air Pilots LLC · Mountain Home, ARBuilt 2004 · S/N T20608498 N206LEFort Worth And Western Air Express LLC · Southlake, TXBuilt 2008 · S/N T20608810 N206LGHotel Kilo Aviation LLC · Anchorage, AKBuilt 2007 · S/N T20608714 N206LLMoondog Motorsports LLC · Missoula, MTBuilt 2012 · S/N T20609058 N206LMQualitair LLC · MichelstadtBuilt 1977 · S/N U20603759 N206MBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2023 · S/N T20609746 N206MDAuction Aviation Inc · Boulder City, NVBuilt 1999 · S/N T20608014 N206MESouthwest Erosion Control · Mckinney, TXBuilt 2025 · S/N T20609816 N206MFMission Aviation Fellowship · Nampa, IDBuilt 2015 · S/N T20609160 N206MNMartin Nelson & Co Inc · Seattle, WABuilt 2006 · S/N T20608646 N206MTBlue Spruce LLC · Bigfork, MTBuilt 1999 · S/N T20608076 N206MZKtbr Holdings LLC · Statesboro, GABuilt 2005 · S/N T20608551 N206PFPatriot Fuels Inc · Alexander, NDBuilt 2025 · S/N T20609817 N206PJIllingworth Paul John · Georgetown, TXBuilt 2008 · S/N T20608876 N206PMTunnel Aviation LLC · Tunnel Hill, GABuilt 2002 · S/N T20608376 N206PQHogue LLC · Paso Robles, CABuilt 2001 · S/N T20608299

Back to AD 71-13-01 R1