Skip to content

Registered aircraft · 3,572

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

N229BADavila Associates · Dorado, PRBuilt 1975 · S/N 17265585 N22RWDenison Scott E · Gainesville, TXBuilt 1976 · S/N 17267495 N23078Pureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 17264080 N230RVEast Tennessee Aviation LLC · Mountain City, TNBuilt 1973 · S/N 17261598 N231SCBice Crystal Harmon · Temple, GABuilt 1974 · S/N 17264523 N23281Sosa Jonathan · Orlando, FLBuilt 1974 · S/N 17264082 N23291Oracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264083 N23353Weems Widener E · San Antonio, TXBuilt 1974 · S/N 17264085 N2345Riotte Frederick · Suffield, CTS/N 17266419 N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438 N234JGBartlett William F · Jackson, WYBuilt 1975 · S/N 17265225 N234VRSnyder Jack W · Cheney, KSBuilt 1976 · S/N 17267422 N234WAWiseman Aviation Inc · Flagstaff, AZBuilt 1975 · S/N 17265581 N2356Dunn Cole E · Florala, ALBuilt 1973 · S/N 17261946 N23DBSky High Farmers LLC · Lakeville, MNBuilt 1975 · S/N 17264474 N23GVCongressional Flying Club · Gaithersburg, MDBuilt 1974 · S/N 17264594 N241KSCrane Kermit J · Topeka, KSBuilt 1973 · S/N 17262602 N241RGAmerican Patrols Inc · Midland, TXBuilt 1973 · S/N 17261916 N242ENorman Brian D · Roseau, MNBuilt 1973 · S/N 17261819 N244DAPrairie Winds Aviation LLC · Overland Park, KSBuilt 1972 · S/N 17261294 N244RTAircraftwings LLC · Las Piedras, PRS/N 17261037 N24GVBoyd Aviation LLC · Nashville, TNBuilt 1975 · S/N 17265760 N24KKFlying High Again LLC · Mt Juliet, TNBuilt 1975 · S/N 17266333 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N254RAReynolds Darryl G · Wills Point, TXBuilt 1975 · S/N 17265910 N257RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266240 N262EEHorizon Flights Corp · Henderson, NVBuilt 1973 · S/N 17261621 N262ERRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 17263854 N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035 N267RAReynolds Darryl G · Wills Point, TXS/N 17261919 N26TFTop Flight Aviation Inc · Corona, CABuilt 1972 · S/N 17261318 N270AMCode 1 Flight Training LLC · Wills Point, TXBuilt 1973 · S/N 17262722 N271AMMonthy Christian · Van Nuys, CABuilt 1973 · S/N 17262510 N271GTBroulik Robert L · Lisbon, IABuilt 1976 · S/N 17267114 N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821 N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439 N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700 N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168 N2777ETop Flight Aviation Inc · Corona, CABuilt 1974 · S/N 17262885 N2777TAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17261147 N277CBN277cb LLC · Jacksonville, FLBuilt 1976 · S/N 17267516 N277SLCharlies Wings LLC · Salisbury, NCBuilt 1973 · S/N 17261652 N27AHM W T Aviation LLC · Jamestown, NYBuilt 1975 · S/N 17265306 N27LASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 17265689 N280MSM & S Air Service Inc · Honeoye Falls, NYBuilt 1973 · S/N 17261450 N29001Geske Sales & Service · Enderlin, NDBuilt 1974 · S/N 17264092 N29006Fancy Inc · Iowa City, IABuilt 1974 · S/N 17264093

Back to Cessna 172M