Skip to content

Registered aircraft · 353

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 ('2072426')
  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 ('2072426')
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.

N35792Drerup Henry J · Sebastopol, CAS/N 17256964 N35795N35795 LLC · Fredericksburg, TXBuilt 1968 · S/N 17256965 N35798Big Sky Aviation LLC · Massillon, OHBuilt 1968 · S/N 17256967 N35799Huebner Otto · Bolingbrook, ILS/N 17256968 N35801Perkins Richard D · East Otto, NYBuilt 1968 · S/N 17256970 N35802Boeing Employees Flying Association Inc · Ridley Park, PAS/N 17256971 N35810Mcintosh Aaron · Caldwell, TXBuilt 1968 · S/N 17256976 N35813Davis Daniel E · Doniphan, MOBuilt 1968 · S/N 17256978 N35815Cm3 LLC · North Las Vegas, NVBuilt 1968 · S/N 17256979 N3909CJames Eric A · Claremore, OKBuilt 1968 · S/N 17257032 N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702 N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013 N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854 N46001Df Kitcar LLC · Red Oak, TXBuilt 1968 · S/N 17256980 N46003Carroll Michael L · Rochester, WABuilt 1968 · S/N 17256981 N46011Jackson William T · Clinton, OHBuilt 1968 · S/N 17256986 N46015Leaders Flying Service LLC · Clear Lake, MNS/N 17256988 N46019La Porte Aero Club Inc · La Porte, INS/N 17256992 N46024Garfield Joshua E · Tampa, FLBuilt 1968 · S/N 17256995 N46027Cleary Thomas J · Fairport, NYBuilt 1968 · S/N 17256997 N46028First Take Aviation LLC · Van Nuys, CABuilt 1968 · S/N 17256998 N46030Constance Air LLC · Luthersville, GABuilt 1968 · S/N 17257000 N46031Soucy Gary J · Brewer, MEBuilt 1968 · S/N 17257001 N46047Loudermilk John A · Nashville, TNBuilt 1968 · S/N 17257010 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034 N46092Breithaupt Tracy L · Alexandria, LAS/N 17257038 N46100Aerflow Inc · Jersey City, NJBuilt 1968 · S/N 17257041 N46101Patel Aman · Wesley Chapel, FLBuilt 1968 · S/N 17257042 N46107Trieber Steven M · Eastport, MEBuilt 1968 · S/N 17257046 N46109Pray Aviation Inc · Augusta, KSBuilt 1968 · S/N 17257047 N46115Capri Aircraft LLC · Madison, VABuilt 1968 · S/N 17257049 N46118Epiphany Software Co · Wilmington, NCBuilt 1968 · S/N 17257051 N46119Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257052 N46122Martin Gregory C Jr · Homer, AKFirst renewal noticeBuilt 1968 · S/N 17257054 N46125East Carolina Aviation LLC · Camden, NCBuilt 1968 · S/N 17257056 N46126Knight Kenneth D · Stoneville, NCBuilt 1968 · S/N 17257057 N46128Meridian Aircraft Leasing LLC · Anniston, ALBuilt 1968 · S/N 17257059 N46130Waltzer Eric · Riverside, CABuilt 1968 · S/N 17257061 N46132N46132 Leasing LLC · Kalispell, MTBuilt 1968 · S/N 17257063 N46133Baham Daniel R · Eunice, LAS/N 17257064 N46143Stromme Shawn · Hazen, NDBuilt 1968 · S/N 17257070 N46144Bhm Corp · Claverack, NYBuilt 1968 · S/N 17257071 N46153Waldemar Mojica · Arecibo, PRBuilt 1968 · S/N 17257074 N46154Spann William J · Dothan, ALBuilt 1968 · S/N 17257075 N46157Gunderson Andrew C · Fond Du Lac, WIBuilt 1968 · S/N 17257077

Back to Cessna 172I