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.

N8780PChampion Milton · Reno, NVBuilt 1965 · S/N 24-4232 N8781PJenkins Aviation Ventures LLC · Woodstock, GABuilt 1965 · S/N 24-4233 N8785FBeving Charles J · Garden City, SDBuilt 1976 · S/N 32R-7780116 N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239 N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241 N878BTBlue Paradise Aviation LLC · Clive, IABuilt 2005 · S/N 3257402 N878MJJackson Air LLC · Paragould, ARBuilt 1976 · S/N 32-7640078 N878MSProvidence Flying LLC · Chillicothe, MOBuilt 2007 · S/N T18208715 N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243 N8792EMann Joshua A · Montgomery, TXBuilt 1976 · S/N 32R-7680178 N8793PFlaagan Kevin D · Beulah, NDBuilt 1965 · S/N 24-4246 N8794PDelaware Mark P · Phoenix, AZBuilt 1965 · S/N 24-4247 N8795PJejgr LLC · Presho, SDBuilt 1965 · S/N 24-4248 N8796PAllie Doug B · Glasgow, MTBuilt 1965 · S/N 24-4249 N8797BDalton Robert Frank · Jackson, CAS/N 32-40149 N8797CMeadowlake Airpark LLC · Lenoir City, TNBuilt 1976 · S/N 32-7640071 N8797PPlant Curtis W · Runge, TXBuilt 1965 · S/N 24-4250 N8798VPalmer Harvey F · Omaha, NEBuilt 1970 · S/N 31014 N8799PMontgomery M Kim · Vega, TXBuilt 1965 · S/N 24-4252 N879CCopper Wings LLC · Gilbert, AZBuilt 2008 · S/N 4692087 N879CBFerris Robert C · Port Washington, NYBuilt 1990 · S/N 27-0039 N87AJdkracl Aircraft LLC · Gretna, NEBuilt 1970 · S/N 27-4594 N87PBH Kyle Sheets Md Pa · Ovalo, TXBuilt 2022 · S/N 4636804 N87TSRwr Air Inc · Tok, AKBuilt 1973 · S/N 31-7300969 N87WTAnd We'Re Off Aviation LLC · Orlando, FLBuilt 2004 · S/N T20608452 N8800PAnp Networks Corp · Las Vegas, NVS/N 24-4253 N8800VLong Jon M · Santee, CABuilt 1973 · S/N 74-31085 N8802PPennington Mitchell T · Medley, WVBuilt 1965 · S/N 24-4257 N8803PWade Brian K · Apalachin, NYBuilt 1965 · S/N 24-4258 N8806PZiolkowski James E · Amarillo, TXBuilt 1965 · S/N 24-4261 N8807PRegistered aircraftBuilt 1965 · S/N 24-4263 N8809PPa24 LLC · Painesville, OHBuilt 1965 · S/N 24-4265 N880BTw880b Leasing LLC · Farmington, UTBuilt 2021 · S/N 4636788 N880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1973 · S/N 31-7305022 N880SCKc Hawgs Inc · Wilmington, DEBuilt 1979 · S/N 32R-8029015 N880SVDiamond Xport LLC · Rochdale, MABuilt 2025 · S/N T18209194 N8812PRegistered aircraftBuilt 1965 · S/N 24-4267 N8813CUlrich Helmut Wiegand · Satellite Beach, FLBuilt 1976 · S/N 32R-7680140 N8813PWolcott Kent E · Colorado Springs, COBuilt 1965 · S/N 24-4268 N8817PTei Corp · Kalispell, MTBuilt 1965 · S/N 24-4273 N8818XBeech Bash In The Bluegrass LLC · Fort Myers, FLBuilt 1973 · S/N 60-0143-063 N8819PN8819p LLC · Boca Raton, FLBuilt 1965 · S/N 24-4275 N881DBJetprop Holdings LLC · Santa Fe, NMBuilt 1989 · S/N 46-22067 N881DTCleary Brothers LLC · Tompkinsville, KYBuilt 1997 · S/N 3257007 N881HPTurbine Conversions Ltd · Nunica, MIBuilt 2000 · S/N T20608234 N881PAAtomic Partners LLC · Oak Ridge, TNBuilt 2009 · S/N T18208960 N8820VDiversified Dialysis Services Inc · Lithonia, GABuilt 1971 · S/N 32-35 N8824PAzimi Matthew H · Navarre, FLBuilt 1965 · S/N 24-4280 N8826PIngalls Equipment LLC · Redlands, CABuilt 1965 · S/N 24-4282 N8828VStebner William R · Crossville, TNBuilt 1971 · S/N 32-40

Back to AD 71-13-01 R1