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.

N32523Heeringa Consruction LLC · Queen Creek, AZBuilt 1974 · S/N 32-7540046 N32570Nevil Aviation LLC · Statesboro, GABuilt 1974 · S/N 32-7540050 N32577Cooper Wayne R · Arcadia, FLBuilt 1974 · S/N 32-7540051 N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016 N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021 N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001 N325DSSchatz Douglas R · Winston Salem, NCBuilt 1974 · S/N 32-7540054 N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005 N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002 N325LCCervantes-Galdeano Lorenzo · Ingalls, KSBuilt 2005 · S/N T20608536 N325MRDv Group LLC · Clovis, CABuilt 2004 · S/N 4636358 N325PAWelling Roger Trustee · Yorba Linda, CABuilt 2001 · S/N 3257237 N325SGTraveling Lill LLC · Key Largo, FLBuilt 1978 · S/N 317812115 N32600Goehl Jeffrey A · College Station, TXBuilt 1974 · S/N 32-7540052 N32655Brewer Gerald W · Sulphur Springs, TXBuilt 1974 · S/N 32-7540055 N326BPEagle Flew LLC · Sanford, NCBuilt 1974 · S/N 32-7540014 N326BWOlsen David A · Marinette, WIBuilt 1990 · S/N 109 N326UWForemost Well Service LLC · Dickinson, NDBuilt 2025 · S/N T18209184 N32706Strembicke Derek R · Owens Crossroads, ALBuilt 1974 · S/N 32-7540060 N32728Marianas Air Transfer Inc · Tinian, MPBuilt 1974 · S/N 32-7540061 N327ADGundry Adam · Superior, WIBuilt 2024 · S/N T18209164 N327HPN327hp LLC · Senoia, GABuilt 2000 · S/N 3257152 N327MTHayden LLC · Tiburon, CABuilt 2019 · S/N T20609559 N327PLOcf Logistics LLC · Canyon, TXBuilt 1981 · S/N 32R-8229011 N327STBeach Cities Real Property Holdings LLC · Hermosa Beach, CABuilt 2005 · S/N T18208447 N32810Knoch Thomas James · Grass Valley, CABuilt 1974 · S/N 32-7540067 N328HPAlan C Perry LLC · Lake Charles, LABuilt 2000 · S/N 3257166 N328TMMathews Thomas J · New Castle, INBuilt 2024 · S/N T18209148 N32919Mbap LLC · Salt Lake City, UTS/N 32-7540074 N32934Robert Craig LLC · Wilmington, DEBuilt 1975 · S/N 32-7540075 N32998Clark Jeffrey Ryan · Greenville, KYBuilt 1975 · S/N 32-7540079 N329CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609130 N329CSOvercast 329 LLC · Jonesboro, ARBuilt 2021 · S/N T20609637 N329KBMagee Brad D · Durango, COBuilt 2007 · S/N T18208788 N329KSWings Flights Of Hope Inc · Orchard Park, NYBuilt 2013 · S/N 4636593 N329RSTeichman David · Dade City, FLBuilt 1963 · S/N 1303-118 N329SDAce Flight Center Inc · St Thomas, VIBuilt 1966 · S/N 27-3512 N329TTJsh Aviation LLC · Dover, DEBuilt 2011 · S/N 4636513 N32BVH Randal Brennan Pa · Vero Beach, FLBuilt 1972 · S/N 32-7240084 N32CGTaylor Group Architects Of California Inc · Fresno, CABuilt 1998 · S/N 27-0245 N32CZElk Mountain Rentals Inc · Waynesville, NCBuilt 2003 · S/N 3255011 N32HDGengerke Ryan · Humble, TXBuilt 1989 · S/N 270031 N32HSFarm Boy Aviation LLC · Boynton Beach, FLBuilt 2006 · S/N T20608645 N32MGPoor Boy Aero LLC · Seminole, TXBuilt 1982 · S/N 32R-8329003 N32MTHeading 406 LLC · Kalispell, MTBuilt 2021 · S/N T20609652 N32PBLease One LLC · Lafayette, INBuilt 1981 · S/N 31-8212006 N32PSDepartment Of The Interior · Boise, IDBuilt 2021 · S/N T20609651 N32SBCook Robert W · Belair, MDBuilt 1976 · S/N 31-7612098 N32SJCutter Southwest Aircraft Sales LLC · Phoenix, AZBuilt 2007 · S/N 3257473 N32TEBlue Line Aviation LLC · Dunbar, NEBuilt 1999 · S/N 3257112

Back to AD 71-13-01 R1