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.

N12522Island Root Aviation LLC · West Palm Beach, FLBuilt 2006 · S/N T20608671 N1258FRsns LLC · Snowflake, AZS/N T20608674 N1258QSiner John R · Kingsport, TNBuilt 1999 · S/N 4636191 N12595Cornell Terry Jason · Bloomsburg, PABuilt 1971 · S/N 27-4725 N125AHPray Ricky Lee Trustee · Woodland Hills, UTS/N T18208240 N125AKBaize Equipment LLC · Crawford, TXBuilt 2004 · S/N T18208320 N125ALNby Productions · Bristow, VABuilt 2021 · S/N T20609639 N125LFHubbard Capital LLC · Nashville, TNBuilt 2023 · S/N T20609729 N125SEDyer John F · Spring, TXBuilt 1969 · S/N 61-0027 N125WWKapotes Nicholas Stephan · Pompton Plains, NJBuilt 1998 · S/N 18280348 N126CAFeltmann Dean A · North Charleston, SCBuilt 1974 · S/N P-257 N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173 N126HJPeterson Charles William · Midway City, CABuilt 1969 · S/N 24-4878 N126KMHessel Aviation LLC · Wilmington, DEBuilt 2007 · S/N T18208701 N126LMMatt Aviation Propertis Inc · Nashua, NHBuilt 2003 · S/N 3257336 N126PCRoots & Wings Aviation LLC · West Simsbury, CTBuilt 1979 · S/N 32R-8029042 N126PKPtk Equipment Inc · Miami Lakes, FLBuilt 2005 · S/N 3257390 N1275RHatter Dan D · Dumas, TXBuilt 1971 · S/N 32-53 N1276AAir Land Ventures 3 LLC · Berwyn, PABuilt 2007 · S/N T20608794 N127CBird Brian A · Duluth, MNBuilt 2013 · S/N 4636604 N127GT7 Golf Tango LLC · Saint Petersburg, FLBuilt 2004 · S/N 3257343 N127JEGillian Michael · Batavia, ILBuilt 2006 · S/N T20608678 N127KHCentral Airlines Inc · Overland Park, KSBuilt 1961 · S/N 500B-1027-38 N1285ROrbit Aviation LLC · Lakewood, CAS/N 31026 N1287TBelle Casa Aero LLC · Tarpon Springs, FLBuilt 1972 · S/N 32-7240111 N128AGarza Family LLC · Helena, MTBuilt 1967 · S/N 32-40354 N128EDSimply Living LLC · Fort Myers, FLBuilt 2000 · S/N 4636258 N128HBSowle LLC · Tampa, FLBuilt 2007 · S/N 3257479 N128MGHastings Gladstone E · Miramar, FLS/N 31-7712074 N128WPPatterson Weldon E · Maryville, TNBuilt 1969 · S/N 32-40579 N1296MThacker Thomas L Trustee · Hurricane, UTBuilt 2008 · S/N T20608803 N1297TReich David W · Fort Lauderdale, FLBuilt 1972 · S/N 32-7240112 N129BBLawson Michael · Englewood, TNBuilt 1969 · S/N 31-481 N129MBYellowfin Air Services LLC · Wilmington, DEBuilt 1971 · S/N 3108 N129RCAirris Aviation & Marine Co · N Fort Myers, FLBuilt 1993 · S/N 27-0173 N12BHMunk-Ee Business Aviation LLC · Linden, MIBuilt 1956 · S/N 157-195 N12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1974 · S/N 27-7405422 N12KWAllied Moulded Products Inc · Bryan, OHBuilt 2000 · S/N 4636255 N12LVR2b2 Enterprises Lllp · Weldon Spring, MOBuilt 1975 · S/N 61-0238-099 N12STWise Ventures LLC · Mooresville, NCBuilt 2006 · S/N 3257412 N12TZJ H O Enterprises Inc · Carol Stream, ILS/N 61-0259-101 N12WZNortech Data Services Inc · Wilmington, DEBuilt 2003 · S/N 2206 N12XLAurora Aviation LLC · Billings, MTBuilt 2004 · S/N 27-0325 N130CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609133 N130DWAttoyac Air LLC · Gonzales, TXBuilt 2021 · S/N T20609662 N130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1999 · S/N T20608130 N130XRM&A Adams Family Lp · Mckinney, TXS/N 32R-7887003 N1315BN1315b Aviation LLC · Wilmington, DEBuilt 2002 · S/N T18208147 N131DLFlyaway Inc · Fort Worth, TXBuilt 2007 · S/N T18208717 N131DTAerownership North American Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N T20609239

Back to AD 71-13-01 R1