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.

N757TTDuellman Todd J · Wisconsin Rapids, WIBuilt 2019 · S/N 4636757 N7582BWandering Chicken LLC · Kalispell, MTBuilt 2024 · S/N T18209151 N758JPR & P Investments Inc · Visalia, CABuilt 1999 · S/N T20608022 N758STDel LLC · North Miami, FLBuilt 2023 · S/N T20609744 N7599LAviation Pursuits Inc · Carrollton, GABuilt 1974 · S/N 31-7400988 N759CHadley Jean C · Benbrook, TXBuilt 2004 · S/N 3257365 N759KLPcw Aviation LLC · Fort Worth, TXBuilt 2021 · S/N T20609631 N75AKC U Later Aviation LLC · Holliday, TXBuilt 2005 · S/N T18208376 N75CPValiair Limited Company · Casper, WYBuilt 2024 · S/N T20609787 N75DRBurton Stuff LLC · Carlsbad, CABuilt 1978 · S/N 32R-7887163 N75GRGreat Frigatebird LLC · Jupiter, FLBuilt 2026 · S/N T20609852 N75JEHammer Motion Pictures Inc · Indianapolis, INBuilt 1975 · S/N 32-7540164 N75KDJp1 LLC · San Angelo, TXBuilt 1998 · S/N 4636178 N75LKN75lk LLC · Lafayette, LABuilt 1981 · S/N 31-8152173 N75PHPaper House Av Inc · Locust Valley, NYS/N 27-0222 N75SGW E Love Ranch · Marfa, TXBuilt 2000 · S/N 3257175 N75WBTransportation One LLC · Missoula, MTBuilt 2010 · S/N 4692142 N7603VHauser Linda L · Ulysses, KSBuilt 1967 · S/N 1331 N7606CKuuluka LLC · Lewes, DEBuilt 1975 · S/N 32R-7680048 N760BLAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2008 · S/N 4692012 N760C2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 2008 · S/N 3257488 N760CSFlorida State Guard · Tallahassee, FLBuilt 2024 · S/N T20609760 N760PSEagle Squadron Inc · The Villages, FLBuilt 1976 · S/N 32R-7680342 N760VRSkyway II LLC · Naples, FLBuilt 1972 · S/N 3138 N7617VSoaring Utah Inc · Sandy, UTBuilt 1967 · S/N 1345 N761CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N T20609572 N761JHPomeroy Cattle Ranch LLC · Kalispell, MTBuilt 2023 · S/N T18209124 N761RBBastin Robet J · Cadiz, KYBuilt 1999 · S/N 3257107 N761SDManta 182t LLC · Park City, UTBuilt 2008 · S/N T18208883 N761WPCook Gary C · Dallas, TXBuilt 2019 · S/N T20609562 N7622FAeronation Aircraft & Exotics LLC · Lewes, DES/N 32R-7780065 N7629VMountain Air Spray Co · Craig, COBuilt 1967 · S/N 1357 N762JMPridgen Michael E · Odenton, MDBuilt 1978 · S/N 32R-7887128 N762SASua 762sa Inc · Palm City, FLBuilt 1979 · S/N 31-7912042 N762VARomeo Holdings LLC · Castle Pines, COBuilt 2021 · S/N 4636785 N7638FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 32-7740014 N7639FArrona David M · San Luis Obispo, CABuilt 1976 · S/N 32R-7780068 N763RCL'Hommecourt Charles John · Ballston Spa, NYBuilt 1993 · S/N 27-0160 N7648VMiller Jerold R · Deering, NDBuilt 1968 · S/N 1376 N7649VBoeing Co · Renton, WABuilt 1968 · S/N 1428 N764JBLance Aviation Inc · Lakeland, FLBuilt 1976 · S/N 32R-7680506 N764MIron Born Manufacturing Inc · Shawnee, OKBuilt 2021 · S/N T20609630 N764WAAlcyone Trust Corp Trustee · Wichita, KSBuilt 2020 · S/N 4636764 N765Moby Partnership · Albuquerque, NMBuilt 1975 · S/N 61P-0271-057 N7650ZKua Textec Inc · Buena Park, CABuilt 2008 · S/N T20608853 N7651HGosbrook Aviation LLC · Lewes, DEBuilt 1973 · S/N 32-7440025 N7655FShining Star Aviation LLC · Zephyr Cove, NVBuilt 1976 · S/N 32-7740015 N765CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N T18208765 N765JMRuppel Willi · Gardnerville, NVBuilt 2006 · S/N T18208576 N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012

Back to AD 71-13-01 R1