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.

N6121YWeaver Scott Allen · North Logan, UTBuilt 1966 · S/N 27-3332 N6124MDiscovery Air LLC · Austin, TXBuilt 2000 · S/N 3257143 N6125YDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-3336 N612JSWings Of Eagle LLC · Leo, INBuilt 1970 · S/N 32-40935 N612RWNby Productions · Bristow, VABuilt 2021 · S/N T20609642 N612SLN612sl Skynance LLC · Marshfield, WIBuilt 2024 · S/N 4636842 N612WWEhecatl LLC · Fort Wayne, INBuilt 1977 · S/N 27-7754114 N612XMexico Medical Missions · Missouri City, TXBuilt 2003 · S/N T18208202 N6137JBradford III Properties LLC · Huntersville, NCBuilt 1976 · S/N 32R-7680309 N6138JLockwood Elijah T · Dayton, OHBuilt 1976 · S/N 32R-7680310 N613DBTigner Steven M · Leesburg, FLBuilt 1999 · S/N 3257091 N613ESRed Devil Aviation LLC · Aberdeen, SDBuilt 2005 · S/N T18208424 N613RAKampa Arnold J · Vero Beach, FLBuilt 1966 · S/N 27-3347 N613SMWiff Robert A · Tahuya, WABuilt 1981 · S/N 32R-8129034 N613WKKnaust Jerry L · Blue Jay, CABuilt 1966 · S/N 27-3344 N6140YSouthern Seaplane Inc · Belle Chasse, LAS/N 27-3353 N61430Arias Aviation Inc · Wilmington, DEBuilt 1974 · S/N 31-7401242 N6145H1100 Flournoy LLC · Alice, TXBuilt 2008 · S/N T18208827 N6146AMartinez Richard Ben · Sammamish, WABuilt 2008 · S/N T18208828 N61470White Jerald W DBA · Jackson, TNBuilt 1974 · S/N 31-7401262 N61490Wings Of Hope Inc · Chesterfield, MOBuilt 1975 · S/N 31-7512004 N6149YRobbins Warren N · Chandler, AZBuilt 1966 · S/N 27-3366 N614HMMuhlbach Robert A · Manhattan Beach, CABuilt 1976 · S/N 61P-0306-080 N614KFGreat Ledge Development Inc · Saint Louis, MOBuilt 1977 · S/N 31-7752136 N614KSDiy Travel LLC · Seattle, WABuilt 2012 · S/N T18209088 N614STMedi-Tek Inc · Antioch, CABuilt 2014 · S/N 4636614 N615CSJerky Holdings LLC · Winter Haven, FLBuilt 2016 · S/N T20609215 N615HMHill Gerald A · Mesa, AZS/N 61P-0311-082 N615KEDesert & Delta Air LLC · San Francisco, CABuilt 2004 · S/N T20608464 N615WMcnamara Donald James · Sunriver, ORBuilt 2012 · S/N 4636556 N6160DAugusta Capital LLC · Hellertown, PABuilt 2008 · S/N T18208832 N6161PTse Jeffrey R · Boulder, COBuilt 2005 · S/N T18208384 N6162DFriedman Steve · Atlanta, GABuilt 2011 · S/N 4636523 N6163YJune2 Holdings LLC · Newark, DEBuilt 2008 · S/N T20608819 N6164XRandall Kyle T · Klamath Falls, ORS/N 500B-1012-33 N6164YStriplin James R Jr · Hartford, ALBuilt 1966 · S/N 27-3383 N6165ZNewman Construction Inc DBA · Riverton, UTBuilt 2008 · S/N T18208809 N6166QSteven K Jonas Pa · New Port Richey, FLBuilt 2008 · S/N T18208808 N6168HWayne Air LLC · Collinwood, TNBuilt 1977 · S/N 32R-7880046 N6169YWiesen Enterprises Ltd · Empire, MIBuilt 1966 · S/N 27-3317 N616ARCenturion Flyers LLC · Spokane, WABuilt 2006 · S/N 3257423 N616JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 4636616 N616JPWb Painting Contractors LLC · Greenville, MSBuilt 1967 · S/N 32-40420 N616RETunnell Shane Michael · Heber, AZBuilt 2007 · S/N T18208772 N6170YGe Org Advanced Systems LLC · Newton, NJBuilt 1966 · S/N 27-3391 N6171HTyler Cherokee 235 LLC · Lindale, TXBuilt 1977 · S/N 32R-7880047 N6173JMinor Michael W · Summerland Key, FLS/N 32R-7680324 N6173QKinder Mark Edward · Bozeman, MTBuilt 2004 · S/N 18281388 N6174JAloms Enterprises LLC · Marietta, GABuilt 1976 · S/N 32R-7680325 N6175UDsd Air LLC · Ft Wright, KYBuilt 2008 · S/N T18208816

Back to AD 71-13-01 R1