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.

N249FMValiair Limited Co Trustee · Casper, WYBuilt 2002 · S/N T20608374 N249MEN249me LLC · Ottumwa, IABuilt 1996 · S/N 27-0216 N249TARkl Consulting LLC · Keizer, ORBuilt 2018 · S/N T20609526 N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049 N24GLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609851 N24KAAllison Kenneth T · Etowah, NCBuilt 1968 · S/N 31-298 N24KWAcme Aviator LLC · Cheyenne, WYBuilt 2004 · S/N 27-0330 N24PMHaven Harmony LLC · Sheridan, WYBuilt 1973 · S/N 310Q0705 N24VRHarris Daniel P · Auburn, ALBuilt 1981 · S/N 32R-8229006 N24WPXv Aviation LLC · Brown City, MIBuilt 1977 · S/N 32R7780482 N24YCBeauchene Air II LLC · Des Moines, IABuilt 1970 · S/N 27-4551 N2507QGift Arthur D Trustee · Wanatah, INBuilt 1977 · S/N 32-7740050 N250AKDb Aviation Holdings Group LLC · Fort Lauderdale, FLBuilt 1979 · S/N 31-7912045 N250BTHeart Gate Enterprises LLC · Pittsburgh, PABuilt 2002 · S/N 4636334 N250DFDmfs Leasing LLC · Des Moines, IABuilt 2026 · S/N 4636878 N250HCCornerstone Air Holdings LLC · Fort Scott, KSBuilt 1977 · S/N 32R-7880037 N250MDInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31-742 N250MELake Superior Aviation Llp · Duluth, MNBuilt 2000 · S/N T20608189 N250PMN250pm LLC · Knoxville, TNBuilt 2014 · S/N 4692204 N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364 N250WAWelch Eric · Lakeland, TNBuilt 1978 · S/N 32-7840102 N251CWInternational Air Services Inc Trustee · Carson City, NVS/N F16 N251DPDisa Air LLC · Laredo, TXBuilt 2022 · S/N T20609693 N251DWWallin Aviation LLC · Taylorsville, UTBuilt 2004 · S/N T18208263 N251MBGolden Eagle Aviators Inc · West Jordan, UTBuilt 2006 · S/N 27-0353 N25206Megwetch Aviation LLC · Auburn, MEBuilt 2025 · S/N T20609823 N2522DMiller Stephen · St Louisville, OHS/N 872 N2529XCpdl Pm LLC · Dallas, TXBuilt 2012 · S/N 4636553 N252CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609126 N252JSVan Bortel Aircraft Inc · Arlington, TXBuilt 2024 · S/N T18209159 N252LTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2022 · S/N T20609695 N252MJThorpe Curtis D · Fredericksburg, TXBuilt 2012 · S/N 4636548 N252QCCereberus LLC · Lewes, DEBuilt 2024 · S/N T18209144 N252VKRobert Thomas Properties LLC · Caro, MIBuilt 2023 · S/N T18209110 N253DSIpmad Vpmc Aerial Mosquito Control · New Iberia, LABuilt 1980 · S/N 31-8052142 N253HLIscil Kaan · Miami, FLBuilt 2021 · S/N 4636779 N253JGFly Good Land Gooder Holdings LLC · Tomah, WIBuilt 2023 · S/N T20609753 N253KMN285dc LLC · Kelso, WABuilt 1990 · S/N 27-0058 N253MAHoosier Doc LLC · South Bend, INFirst renewal noticeBuilt 2004 · S/N 4636353 N253TMBack Of Beyond Aviators Inc · New Braunfels, TXBuilt 1989 · S/N 27-0004 N2545HNoble Aviation Enterprises LLC · Phoenix, AZBuilt 2012 · S/N 4636561 N2549DLkd & Associates Inc · Monroe, GAS/N 4692178 N254CSVallencourt Construction Co Inc · Green Cove Springs, FLBuilt 2017 · S/N T20609254 N254HTFly254 LLC · Waco, TXBuilt 1993 · S/N 4622127 N255AVPaula Stewart LLC · Saipan, MPBuilt 2015 · S/N GA8-TC-320-15-215 N255DSAircraft LLC · Battle Ground, WABuilt 1982 · S/N 328224006 N255GCorcoran Frank · Rochelle, ILS/N 32R-7887180 N255TMGiles Durham K · Davis, CABuilt 2012 · S/N T20609068 N2568MDe La Cruz Ronaldo · Cape Coral, FLBuilt 1979 · S/N 27-7954079 N256MBMunobraca LLC · Mcallen, TXBuilt 1999 · S/N T20608116

Back to AD 71-13-01 R1