Skip to content

Registered aircraft · 303

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

N6356GBettega Gerald E · Lutz, FLBuilt 1970 · S/N 15071856 N6361GHalley Dan R · Avery, TXBuilt 1970 · S/N 15071861 N6363GGillis Timothy L · Kenai, AKBuilt 1970 · S/N 15071863 N6364GCarlstadt William A · South Bound Brook, NJBuilt 1970 · S/N 15071864 N6365GN6365g LLC · Buckeye, AZBuilt 1970 · S/N 15071865 N6366GTownson Charlotte K · Cisco, TXBuilt 1970 · S/N 15071866 N6374GLilbit Industries LLC · Oklahoma City, OKBuilt 1970 · S/N 15071874 N6378GHigh Exposure Inc · Wilmington, DEBuilt 1970 · S/N 15071878 N6386GSonafrank Eric · Somerset, INBuilt 1970 · S/N 15071886 N6388GGaller Frank G · Elysian, MNBuilt 1970 · S/N 15071888 N6389GHagen Alfred · Bensalem, PABuilt 1970 · S/N 15071889 N6398GCrowned Eagle Aviation LLC · South Saint Paul, MNBuilt 1970 · S/N 150-71898 N6400GCollier James S · Jesup, GABuilt 1970 · S/N 15071900 N6403GKassel Willard C · Sicily Island, LAS/N 15071903 N6404GWarrior Aviation LLC · Prior Lake, MNBuilt 1970 · S/N 15071904 N6405GArmond Richard J · Thousand Oaks, CABuilt 1970 · S/N 15071905 N6411GL-Bird LLC · Hood River, ORBuilt 1970 · S/N 15071911 N6414GBurks Aviation Inc · Hattiesburg, MSBuilt 1970 · S/N 15071914 N6416GRolin Brian · Mc David, FLBuilt 1970 · S/N 15071916 N6424GWolcott Dennis L · Jasper, FLBuilt 1971 · S/N 15071924 N6426GWalker Raymond C · Big Fork, MTBuilt 1970 · S/N 15071926 N6427GWoods Eric V · Fort Washington, MDBuilt 1970 · S/N 15071927 N6431GSoule Clauson D · Cooperstown, NYBuilt 1970 · S/N 15071931 N6435GMountain Home Aviation Llp · Mountain Home, IDBuilt 1970 · S/N 15071935 N6438GAero Equities LLC · Ventura, CAS/N 15071938 N643GAir Leasing Inc · Evanston, ILS/N 15071543 N6444GBillman Ryan Patrick · Phoenix, AZS/N 15071944 N6446GHill Jonathan T · Taylorsville, KYS/N 15071946 N6447GVan Holten Robert W · Flemington, NJBuilt 1970 · S/N 15071947 N6448GBradley Gilbert K · Sun Prairie, WIBuilt 1970 · S/N 15071948 N6449GAlbania Emad R · Huntingtown, MDBuilt 1970 · S/N 15071949 N6453GBegley Scott R · Fairbanks, AKBuilt 1970 · S/N 15071953 N6457GN19752 LLC · Toledo, WAS/N 15071957 N6461GDrewry James D · Scottsboro, ALS/N 15071961 N6469GMaxwell Daniel · Albuquerque, NMBuilt 1970 · S/N 15071969 N6479GGibbons Asher · Mobile, ALBuilt 1970 · S/N 15071979 N6480GLloyd Trent E · Central Valley, UTBuilt 1970 · S/N 15071980 N6483GPeterson Cassandra L · Poplar Grove, ILBuilt 1970 · S/N 15071983 N6486GRomeo Aviation Inc · Cumberland, WIBuilt 1970 · S/N 15071986 N6487GRedell Donald J · Lake Geneva, WIBuilt 1970 · S/N 15071987 N6488GKrog Steven L · Hartford, WIBuilt 1970 · S/N 15071988 N6496GJbm Aviation LLC · Mc Leansboro, ILS/N 15071996 N6497GLynch David C · Columbus, INBuilt 1970 · S/N 15071997 N6499GSkadberg Christen G · Knife River, MNBuilt 1970 · S/N 15071999 N747KYMahany John S · Long Beach, CABuilt 1970 · S/N 15071860 N770SPHa Emily J · Fort Worth, TXBuilt 1970 · S/N 15071805 N7LSChabrian Peggy · Port Orange, FLBuilt 1969 · S/N 15071402 N8044ZLever Samuel C · Udall, KSS/N 15071255 N807KSKansas State University Salina · Salina, KSBuilt 1969 · S/N 15071287 N827DFBrown Edward M · Cabot, ARBuilt 1970 · S/N 15071994

Back to Cessna 150K