Skip to content

Registered aircraft · 683

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2072401')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072401')
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.

N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387 N393ESLanier Equipment Leasing LLC · Gainesville, GABuilt 1997 · S/N 17280138 N397ESN397es Holding LLC · Palm City, FLBuilt 1997 · S/N 17280164 N398ESChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280156 N399ESBray Aviation LLC · Calera, OKBuilt 1997 · S/N 17280155 N402ERLeighnor Aircraft LLC · Prescott, AZBuilt 1997 · S/N 17280242 N402PEDiegos Pet Rescue LLC · Orlando, FLBuilt 1998 · S/N 17280594 N403FRBas Part Sales LLC · Greeley, COS/N 17280245 N404FREdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280282 N405ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280219 N406FRLunken Flight Training Center LLC · Cincinnati, OHS/N 17280297 N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937 N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234 N408ESRussell Robert Q · Genoa City, WIBuilt 1997 · S/N 17280226 N4097MN4097m LLC · Boynton Beach, FLBuilt 1998 · S/N 17280322 N409ESN409es LLC · Stuart, FLBuilt 1997 · S/N 17280231 N410LRWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280257 N411ESAttitude Aviation Inc · Livermore, CABuilt 1997 · S/N 17280223 N413ESAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280218 N4172PDmac Aircraft LLC · Savannah, GABuilt 1997 · S/N 17280288 N418ESWright Aero Inc · Saint Cloud, MNBuilt 1998 · S/N 17280358 N4190PChaleff George S · Johnson, VTBuilt 1998 · S/N 17280620 N4190VAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280626 N41912Eastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280628 N4193RHunter Jeffrey Jay · Shreveport, LABuilt 1998 · S/N 17280636 N42007Southeastern Oklahoma State University · Durant, OKBuilt 1999 · S/N 17280744 N4202LAa-Aero LLC · Fairfield, NJBuilt 1999 · S/N 17280747 N4203PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 17280748 N420ERAtp Aircraft 2 LLC · Wilmington, DEBuilt 1998 · S/N 17280634 N420URcs Services LLC · California, MDBuilt 1997 · S/N 17280120 N421FPJustus Christopher S · Corona, CABuilt 1998 · S/N 17280638 N426EPKentucky Airmotive Inc · Mount Sterling, KYBuilt 1998 · S/N 17280647 N426ESWeaver Corey E · Saline, MIBuilt 1997 · S/N 17280263 N427EPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280606 N428FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281228 N429EPBbm Air LLC · Macon, GAFirst renewal noticeBuilt 2001 · S/N 17280608 N429ESBarbers Point Flight School LLC · Kapolei, HIBuilt 1997 · S/N 17280296 N429FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281229 N42RLChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280405 N430EPFly La Wings LLC · Glendale, CAS/N 17280648 N430UCheyenne LLC · West Mifflin, PABuilt 1997 · S/N 17280121 N431FRN3812q LLC · San Diego, CABuilt 1997 · S/N 17280301 N432ERUnicorn Wings LLC · Cary, ILBuilt 1998 · S/N 17280652 N433FRKtoa Rentals LLC · Torrance, CABuilt 1997 · S/N 17280292 N434EPNashville Flight School LLC · Nashville, TNBuilt 1998 · S/N 17280655 N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441 N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278 N445AFPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 17280445 N445BWFlight Operations Aircraft LLC · Wilmington, DES/N 17280662 N446AFBeale Air Force Base Aero Club · Beale Afb, CABuilt 1998 · S/N 17280446

Back to Cessna 172R