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.

N74LRRemy Lange · East Greenville, PAS/N 27-7405363 N74MJFord Richard M · Cartersville, GABuilt 1977 · S/N 31-7712065 N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272 N74PYPapa Yankee LLC · Cameron, MTBuilt 2009 · S/N T20608870 N74SHStreebin David A · Elkhorn, NEBuilt 2008 · S/N T18208847 N74WDNevada Viking Partners LLC · Stateline, NVBuilt 1973 · S/N 73-31065 N75014Hammonds Hangars Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680246 N75034Rpm Aviation LLC · Hillsborough, NCBuilt 1976 · S/N 32R-7680248 N7503SStout Joel D DBA · New Cumberland, PAS/N 61-0066-122 N7507SBlue Sky Aviation Inc · Texico, NMBuilt 1970 · S/N 61-0068-126 N7509SBlueskys Inc · Wilmington, DEBuilt 1970 · S/N 60-0056-128 N750AWMagumbo Aviation LLC · Macomb, MIBuilt 1974 · S/N 32-7540018 N750GVTrak Inc · Gainesville, GABuilt 2000 · S/N 3257171 N75143Raisch Horst F · Aptos, CABuilt 1976 · S/N 32R-7680263 N75195Swaz Aviation LLC · Mesa, AZS/N 32R-7680277 N75196Woodberry Robert A · Mineral, VABuilt 1976 · S/N 32R-7680278 N751CCMenlo Aviation LLC · Camden, DEBuilt 2023 · S/N 4636831 N75247G W R LLC · Wilmington, DEBuilt 1976 · S/N 32R-7680282 N75267Avian Aerospace LLC · Mansfield, OHBuilt 1976 · S/N 32R-7680284 N75279Workman Randy C · Bells, TXBuilt 1976 · S/N 32R-7680285 N7528SDoran Jeff T · Westerville, OHS/N 60-0190-086 N75298Registration Pending · Memphis, MORegistration pendingS/N 32R-7680287 N75299Rmb Helicopters LLC · Factoryville, PABuilt 1976 · S/N 32R-7680289 N752ESGoodrich Jesse R · Vernal, UTBuilt 2023 · S/N T18209115 N752LSouthwest Aviation Enterprises · Haslet, TXBuilt 2006 · S/N T20608595 N752SEAtkins Alvin R Trustee · Barnstead, NHBuilt 2012 · S/N GA8-TC 320-12-183 N7533CWilson Rodney D · Whiteville, TNBuilt 1975 · S/N 32-7640045 N7533SD & T Wilson Co Inc · Hillsboro, INBuilt 1974 · S/N 60-0165-073 N75387Latitude 63 LLC · Anchorage, AKBuilt 1976 · S/N 32R-7680298 N75397Modern Farm LLC · Chandler, AZBuilt 1976 · S/N 32R-7680301 N75398Skybochs LLC · Kaysville, UTS/N 32R-7680302 N753CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N T18208653 N753WSSulimoff Wesley Thomas · Lake Havasu City, AZBuilt 2002 · S/N T20608309 N754SEInternational Air Services Inc Trustee · Carson City, NVBuilt 2012 · S/N GA8-TC 320-12-174 N754WAGreenview Renewables LLC · Folsom, CABuilt 2019 · S/N 4636754 N7550SDoctors Diet Inc · Nashville, TNBuilt 1974 · S/N 61P-0181-011 N7551FBushwackers Leasing LLC · Calera, OKS/N 32R-7780062 N7553LSayers James B · Edison, OHFirst renewal noticeBuilt 1972 · S/N 31-7300936 N7559KSkyway II LLC · Naples, FLS/N P21000410 N755BNicholson Enterprises LLC · Oconomowoc, WIBuilt 2024 · S/N T20609779 N755FGBarker Consulting Group LLC · Hickory, NCBuilt 2019 · S/N 4636755 N755RKNorman Vick Construction Inc · Columbus, WIBuilt 1978 · S/N 32R-7887026 N755TTBarab Jesse · Yonkers, NYBuilt 1996 · S/N 27-0215 N755VSRosgen Kenneth-Ray C · Georgetown, TXS/N 32-7440039 N756DDAirade LLC · Davis, CABuilt 2004 · S/N T18208229 N756FRobertson Lisa O · Jackson, WYBuilt 2005 · S/N T20608544 N756TBTrehus Eric M · San Jose, CABuilt 1990 · S/N 27-0047 N7576YJ & P Toys Inc · Fort Myers, FLBuilt 1968 · S/N 27-4076 N757DDBosco74 LLC · Wilmington, DEBuilt 1966 · S/N 1652-9 N757RBTaa Aviation LLC · Lewes, DEBuilt 2004 · S/N T20608460

Back to AD 71-13-01 R1