Registered aircraft · 6,916

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.

N793HFMid Continental Aviation LLC · Wilmington, DEBuilt 2007 · S/N T20608793 N793STPoor Boy Aviation LLC · Wilmington, DEBuilt 2024 · S/N T18209157 N7942CN4143w LLC · Los Gatos, CABuilt 1975 · S/N 32R-7680069 N794RSRegistered aircraftS/N 27-0007 N794SATmb Aviation LLC · Fresno, CABuilt 2001 · S/N T18208062 N7951CJaybec Corp · Pinecrest, FLBuilt 1975 · S/N 32R-7680070 N7952CKramer Kartie K · Mckinney, TXBuilt 1975 · S/N 32R-7680071 N795ABam Diversified Services LLC · Athens, TXBuilt 2014 · S/N 4636618 N795DHSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N T20609061 N795JBMountain High LLC · Ketchum, IDBuilt 1969 · S/N 24-4894 N795MAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 4636007 N7967VAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 1576 N7968PDavison William A · Hamilton, MTBuilt 1962 · S/N 24-3205 N796CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T18209196 N7970PStevens Jon A · Byron, MNBuilt 1962 · S/N 24-3207 N7975PB&R Aircraft LLC · Wadsworth, OHBuilt 1962 · S/N 24-3212 N7978PKozak Aeronautical Company · Wilmington, DEBuilt 1962 · S/N 24-3215 N797BBKurt Aviation · Middleton, DEBuilt 2002 · S/N T18208148 N797MAJtcc Products LLC · Fairview Park, OHBuilt 1997 · S/N 4636108 N797MCTim 2 Fly LLC · Conroe, TXBuilt 1997 · S/N 4636117 N797SLow Wing 797 LLC · Aurora, ILBuilt 1997 · S/N 3257003 N797VCSantana Carlos A · San Juan, PRBuilt 1966 · S/N 27-3439 N7983YMclaughlin Scott A · Defiance, IABuilt 1966 · S/N 30-1085 N7984PMiller Jason Christopher · Woodbury, NJBuilt 1962 · S/N 24-3222 N7988HTc Loox Consultants LLC · Washington, DCBuilt 1984 · S/N 60-8423021 N798BSBurnkey Aviation LLC · Declo, IDS/N 32R-7887020 N798NGSouthwest Aviation Enterprises · Haslet, TXBuilt 2014 · S/N T20609153 N7991VNorth Carolina Soaring Association · Zebulon, NCBuilt 1970 · S/N 1586 N7993PMartz Todd B · Pleasant Hill, CABuilt 1962 · S/N 24-3232 N7998VDonica Leldon H · Marana, AZBuilt 1970 · S/N 1589 N799CERed Oar Aviation LLC · Lookout Mountain, TNS/N 1807-17 N799GFNorth Dakota Game And Fish Dept · Bismarck, NDBuilt 2006 · S/N T18208487 N799JPAirship Zulu Productions LLC · Wilmington, DEBuilt 2022 · S/N 4636799 N79AKGlobal Aircraft Trust Inc · Cheyenne, WYBuilt 1969 · S/N 31-472 N79AUEpsman Kenneth A · Santa Clara, CABuilt 2007 · S/N 3257463 N79BLDefying Gravity Inc · Litchfield, ILBuilt 2014 · S/N 4636623 N79BTN79bt LLC · Arlington, TXBuilt 2022 · S/N T20609686 N79LDTcb Aviation LLC · Evansville, INBuilt 1982 · S/N 31-8252062 N79LKGonzalez Leon · Pembroke Pines, FLBuilt 1980 · S/N 31-8012092 N79MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1999 · S/N 232 N7ACCommander Quest LLC · San Luis Obispo, CABuilt 1961 · S/N 500B-1013-34 N7AZDevaney Aviation Inc · Palm City, FLBuilt 1968 · S/N 27-3964 N7CBExperimental Aircraft Association · Oshkosh, WIBuilt 1972 · S/N 27-4802 N7FMAppalachian Racing Aviation LLC · Johnson City, TNBuilt 1971 · S/N 32-7240041 N7HWAltieri Frank J · Somerton, AZBuilt 1967 · S/N 27-3718 N7HXBlairtogaii Inc · Novi, MIBuilt 1982 · S/N 32-8224005 N7JVGreer Air Inc · Saint Cloud, FLBuilt 1971 · S/N 31-789 N7LLBautista Sean P · Reedley, CABuilt 1974 · S/N 310Q1019 N7PQStarr James Trey · Oklahoma City, OKBuilt 1976 · S/N 14096 N7XACine Aviation Inc · W Bloomfield, MIBuilt 1981 · S/N 32R-8229020

Back to AD 71-13-01 R1