Skip to content

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.

N819CCCapital Holdings 217 LLC · Jackson, TNBuilt 1993 · S/N 27-0158 N819PSWoodard William R · University Place, WABuilt 2003 · S/N 18281241 N819SGSunstate Aviation Inc · Kissimmee, FLBuilt 2024 · S/N T18209160 N819TAStout Brent B Trustee · Hickman, CAS/N T18208192 N81CHRegistration Pending · Elkhorn, WIRegistration pending, canceledBuilt 2008 · S/N T18208880 N81DMArcanum LLC · Lake Orion, MIBuilt 1998 · S/N 27-0252 N81EDNav-Pete LLC · Memphis, TNBuilt 1979 · S/N 31-7952220 N81KVGrosulak Dale M · Reno, NVBuilt 2023 · S/N T18209106 N81LMMission Flight Academy · Yucaipa, CABuilt 1969 · S/N 32-40699 N81PRValiair Lc Trustee · Casper, WYBuilt 2006 · S/N T20608699 N81RHSpecialty Aviation II LLC · Jupiter, FLBuilt 1972 · S/N 31-7300909 N81STAxion Inc · Huntsville, ALBuilt 1980 · S/N 32-8024036 N82008Craige Danny D Trustee · Durant, OKBuilt 1980 · S/N 32R-8029089 N8206EA Kelly Aviation LLC · New Braunfels, TXBuilt 1982 · S/N 32-8224009 N8206HJonathan Designs Inc · Cape Coral, FLBuilt 1982 · S/N 32R-8213046 N82097Argosy Venture Corporation · Pagosa Springs, COBuilt 1982 · S/N 32R-8229052 N820FSAir Arctic Inc · Fairbanks, AKBuilt 1979 · S/N 317952185 N8210HSlap Shot Aviation LLC · Parker, COBuilt 1982 · S/N 32R-8229054 N8212PTweeddale Thomas Allan · Denton, TXBuilt 1963 · S/N 24-3465 N8214EWayland Steven L · Southlake, TXBuilt 1980 · S/N 32R-8029092 N8214HRuetsch Derek R · Goodyear, AZBuilt 1980 · S/N 32R-8029093 N8214QB & B Flying LLC · Green River, WYBuilt 1980 · S/N 32R-8029096 N82173Gagnier Hugh K · Hidden Hills, CABuilt 1982 · S/N 32R-8229055 N8218AFirst Flight Inc · Watertown, CTBuilt 1982 · S/N 32R-8229064 N8218KN8218k LLC · Chico, CABuilt 1982 · S/N 32R-8229063 N821FASlavin Marc · Berlin, MDBuilt 2003 · S/N T18208210 N821HCAxel Farms LLC · Colusa, CABuilt 2008 · S/N T20608846 N821RGCircle Z Construction LLC · Mancos, COS/N T20609110 N821RRAir Charter Inc DBA · Culebra, PRBuilt 1973 · S/N 338 N8220QWallentine Ranch LLC · Dover, DEBuilt 1980 · S/N 32R-8029097 N8220WSb Farms LLC · Bowling Green, OHBuilt 1980 · S/N 32R-8029099 N8221PMoreau Donald G · Dayton, TXBuilt 1963 · S/N 24-3474 N8222PWeirich Joseph J · South Milwaukee, WIBuilt 1963 · S/N 24-3475 N8225RNorris Craig A · San Carlos, CABuilt 1980 · S/N 32R-8029100 N82279Boyce Peter C · New Albany, INBuilt 1980 · S/N 32-8024027 N8228ASlater Charles · Delafield, WIBuilt 1980 · S/N 32R-8029101 N8229EJones Bert F · Philipsburg, MTBuilt 1982 · S/N 32R-8229057 N822HWCwm Air LLC · Lewes, DEBuilt 2004 · S/N T20608475 N822JPTakacs Mark · Ada, MIBuilt 1984 · S/N 32R-8429022 N822TPRemington Rental LLC · Chandler, AZBuilt 2006 · S/N T20608604 N82303Rosales James Ian III · Bryan, TXBuilt 1980 · S/N 32R-8029103 N8232AAero2nautical LLC · Marion, OHBuilt 1980 · S/N 32-8024029 N8234JCannoles Ronald · Las Vegas, NVBuilt 1979 · S/N 6006387961202 N8235AEdgar E Herbert · Bowerston, OHBuilt 1980 · S/N 32R-8029104 N8236RBellanca LLC · Galena, KSS/N 32-67 N8238DAviation Therapy LLC · Livingston, NJBuilt 1980 · S/N 32-8024030 N8238PByer Connor · Brenham, TXBuilt 1980 · S/N 32-8024033 N823EGWashington State Patrol · Olympia, WABuilt 2025 · S/N T20609807 N823WWHoffman Richard D · Waterford, WIBuilt 1997 · S/N 20017 N8241ABaloga David M · Payson, AZBuilt 1982 · S/N 32R-8229060

Back to AD 71-13-01 R1