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.

N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004 N159BOppold Robert S · Overland Park, KSBuilt 1977 · S/N 27-7754047 N159DMLe Kenneth · Henderson, NVBuilt 2000 · S/N 2005 N159HPCalifornia Highway Patrol · Sacramento, CABuilt 2018 · S/N GA8-TC-320-18-246 N159KMHeritage Aviation Management Ltd · Conroe, TXBuilt 2020 · S/N T20609606 N15CASpirit Of Life Ministries International Inc · Carthage, TXBuilt 2005 · S/N 3257401 N15EASwanson Blake J · Ketchum, IDBuilt 2001 · S/N T20608333 N15EFEastern Aviation Fuels Inc · New Bern, NCBuilt 1999 · S/N 4636195 N15FGShannon Jesse Lee · Boise City, OKBuilt 1975 · S/N 27-7554112 N15REGreat Alaskan Flooring Inc · Kodiak, AKBuilt 1968 · S/N 27-4068 N15SNRobinson Brian · Bedford, NHBuilt 2001 · S/N 25074C N15XJSt Express LLC · El Segundo, CABuilt 2022 · S/N 4636796 N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966 N160TTStraightline Private Air LLC · Denver, COBuilt 2017 · S/N T20609505 N160XMalolo LLC · San Luis Obispo, CAS/N 500B-1300-115 N161BLAirborne Holdings Inc · Midlothian, TXBuilt 1965 · S/N 1551-197 N161CSAlberco LLC · Lovell, MEBuilt 2013 · S/N T20609101 N161MABarnes Gordon R · Manalapan, NJBuilt 2000 · S/N 3257161 N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106 N161SPCalifornia Department Of Parks And Recreation · Mcclellan, CABuilt 2021 · S/N T20609667 N16253Quincy Aircraft LLC · Quincy, ILS/N 32-7340080 N16269Kelley John Charles · Hot Springs Ntl, ARBuilt 1973 · S/N 32-7340081 N1630WN O Good LLC · Wade, NCBuilt 2011 · S/N 4636508 N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228 N16372Blue Bird Aviation LLC · Zephyr Cove, NVBuilt 1973 · S/N 32-7340083 N163AWMccall Andrew Keith · Abilene, TXBuilt 2002 · S/N T18208163 N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210 N163DDN163dd LLC · Columbus, MTBuilt 2007 · S/N T18208707 N163STD&E Aircraft LLC · Newark, OHBuilt 2010 · S/N 4692143 N1640PBucher Max · Fort Mohave, AZBuilt 1978 · S/N 32R-7887221 N16415United Aviation LLC · Prospect, KYS/N 32-7340085 N164412c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 32-7340087 N1646ZDmitry P Kudryn · Wasilla, AKBuilt 1962 · S/N 185-0446 N16487Piper Cherokee LLC · Seal Beach, CABuilt 1973 · S/N 32-7340090 N16498Owens Hay LLC · Crane, ORBuilt 1973 · S/N 32-7340091 N164JAgster Robert J · Fstrvl Trvose, PABuilt 1980 · S/N 32R-8029071 N1652NAllison Christopher · Cartersville, GABuilt 1999 · S/N 3257119 N16542Marianas Air Transfer Inc · Saipan, MPS/N 32-7340093 N165PWCounty Of San Bernardino · San Bernardino, CABuilt 2014 · S/N GA8-TC 320-14-205 N165TTMakushin Logistics LLC · Fairbanks, AKS/N 318452005 N166CBStar Ground Services Inc · Tinian, MPBuilt 1973 · S/N 32-7440032 N166CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N T18208319 N166MABryant Kristy D · Mckinney, TXBuilt 2009 · S/N 4692120 N166PAMacmillan Performance LLC · Torrance, CABuilt 2012 · S/N T18209060 N1684ZPetty Venture Investment LLC · Scottsdale, AZBuilt 2007 · S/N T18208757 N168GFC2c LLC · Christiansted, VIS/N 4636189 N16917Degraffenreid Ronald A · Shawnee, OKBuilt 2007 · S/N T18208803 N1692LSheldon Steven R · Las Vegas, NVBuilt 2007 · S/N T18208804 N1694LAccg Holdings LLC · Hyde Park, UTBuilt 2007 · S/N T20608783 N169RBSfo Air LLC · Dallas, TXBuilt 2015 · S/N T20609183

Back to AD 71-13-01 R1