Skip to content

Registered aircraft · 1,636

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

N4774PCannan Aviation Inc · Georgetown, TXBuilt 1980 · S/N 15284813 N4777HMorey Airplane Co Inc · Middleton, WIBuilt 1979 · S/N 15283978 N47791Schwartz John E · Ventura, CABuilt 1979 · S/N 15283250 N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253 N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258 N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633 N4786PAce High Aviation LLC · Long Beach, CAS/N 15284816 N478BKWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15281022 N4791QSelzer Robert S · Anchorage, AKBuilt 1981 · S/N 15285063 N47930Nextgen Flight Academy Inc · Riverside, CAS/N 15283263 N4800MDunn Bernard P · Carson City, NVBuilt 1980 · S/N 15284484 N48024Aftcloud Inc · Ontario, CABuilt 1979 · S/N 15283270 N48033Franconi Michael J · Newington, CTBuilt 1979 · S/N 15283271 N48042Simmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 15283273 N48056Little Duke Aviation LLC · Saint Paul, MNBuilt 1979 · S/N 15283276 N48068Ikarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N 15283277 N4806BMckinney Brett A · Hackleburg, ALBuilt 1979 · S/N 15283647 N4807BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283648 N48156Perdue Ralph R Jr · Blacklick, OHBuilt 1979 · S/N 15283291 N48167American Aviation Inc · Brooksville, FLBuilt 1979 · S/N 15283293 N4817BPriority One Insurance & Investments Inc · Hillsboro, NDBuilt 1979 · S/N 15283653 N4819BSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283654 N48204Young Achilles Hsi-Jung · La Habra, CABuilt 1979 · S/N 15283301 N48222N1705r Inc · Cobb, CAS/N 15283303 N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304 N48238Hamilton Brandon T · Morehead, KYBuilt 1979 · S/N 15283306 N48239Harrell Robert L · Brooksville, FLBuilt 1979 · S/N 15283307 N4823LLaguna Verde Leasing Inc · Wilmington, DES/N 15284233 N48241Evans Christopher Warren · Demotte, INBuilt 1979 · S/N 15283308 N48244Kelly Kevin J · Lancaster, NYBuilt 1979 · S/N 15283310 N4824PMikhailau Ivan · Alpine, UTBuilt 1980 · S/N 15284823 N48270Stephenson Christopher J · Rindge, NHBuilt 1979 · S/N 15283315 N48286Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283320 N4828BGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 15283660 N4829PBoard Of Trustees Of University Of Illinois · Savoy, ILBuilt 1980 · S/N 15284824 N48306Bargo Marvin Rae Jr · London, KYBuilt 1979 · S/N 15283323 N4830BRussell Dwight R · Milo, MEBuilt 1979 · S/N 15283661 N48333Central Texas College · Killeen, TXBuilt 1979 · S/N 15283324 N48340Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15283326 N4838BAerolina Inc · Hendersonville, NCBuilt 1979 · S/N 15283665 N48400Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283332 N48410Azar Suzanne S · El Paso, TXS/N 15280907 N4843BMaddox Emily Brown · Rosharon, TXBuilt 1979 · S/N 15283668 N48440Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280910 N4847BCrossbrook LLC · Willoughby, OHBuilt 1979 · S/N 15283670 N48481Oklahoma State University · Stillwater, OKBuilt 1979 · S/N 15283342 N48500R&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 15280914 N4850HGreen Airport Development Corp · Kemah, TXBuilt 1979 · S/N 15283985 N4851BCode Supplies Inc · Lakeland, TNBuilt 1979 · S/N 15283673 N48521Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283346

Back to Cessna 152