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.

N101FLElsing Germain J · Rushmore, MNBuilt 1970 · S/N 15071541 N1032MHoyer Bryan H · Friday Harbor, WABuilt 1970 · S/N 15071732 N1037MHager Winfield D · Peytona, WVBuilt 1970 · S/N 15071737 N104SKAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 15071907 N1133MRobinson Lanis A · Clanton, ALBuilt 1970 · S/N 15071733 N1135MLopez Ferco Capdevila · Port Saint Lucie, FLS/N 15071735 N1136MHiggins Derrick · Arbyrd, MOBuilt 1970 · S/N 15071736 N11JTJjj Ventures LLC · Bronx, NYBuilt 1969 · S/N 15071181 N150Beam David · Sabina, OHBuilt 1969 · S/N 15071659 N150EGGreene Harry L · Waipahu, HIBuilt 1969 · S/N 15071635 N150PHJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15071474 N150SHArnold Drusilla · Descanso, CABuilt 1969 · S/N 15071506 N150VMRegistered aircraftBuilt 1969 · S/N 15071200 N1728QUnd Aerospace Foundation · Grand Forks, NDBuilt 1970 · S/N 15071920 N2135GCrawford Mark E · Pleasant Ridge, MIBuilt 1970 · S/N 15071682 N2454QTracemont Flyers LLC · Boyce, LABuilt 1969 · S/N 15071341 N301GWCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1969 · S/N 15071678 N311SGRapattoni Ryan · Los Angeles, CABuilt 1969 · S/N 15071161 N38WTReed Brian A · Kilgore, TXBuilt 1969 · S/N 15071384 N4291WN4291w LLC · Orlando, FLBuilt 1969 · S/N 15071397 N543VKHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071227 N561GSSandberg David C · Auke Bay, AKBuilt 1969 · S/N 15071487 N562GSHermann Andrew L · Kindred, NDBuilt 1969 · S/N 15071509 N563GSGilderhus Edwin T · Oberon, NDS/N 15071468 N5653GCavanaugh Joseph Rex · Alvin, TXBuilt 1969 · S/N 15071153 N5654GNorman Charles E · Zanesville, OHBuilt 1969 · S/N 15071154 N5655GAnderson Kevin G · Pleasant Hill, CABuilt 1969 · S/N 15071155 N5656GLet There Be Flight LLC · Portage, MIBuilt 1969 · S/N 15071156 N5659GLacy Melodi J · Swanton, VTBuilt 1969 · S/N 15071159 N5660GLawrence Corey R · Bourbon, MOBuilt 1969 · S/N 15071160 N566GSPomeroy Cattle Ranch LLC · Kalispell, MTS/N 15071446 N5672GHarrold Adam T · New Waterford, OHBuilt 1969 · S/N 15071172 N5675GGray Mark J · Muncie, INBuilt 1969 · S/N 15071175 N5676GSchmidt Gary L · Afton, MNS/N 15071176 N5677GFredenburg Justin N · Edgeley, NDS/N 15071177 N5683GCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 15071183 N5687GChilders Roderick G · Red Banks, MSBuilt 1969 · S/N 15071187 N5688GFriends Of Jesus · Poughkeepsie, ARBuilt 1969 · S/N 15071188 N5693GScott Jerry · Wingate, TXBuilt 1969 · S/N 15071193 N5694GN528r LLC · Auburn, ALBuilt 1969 · S/N 15071194 N5696GLowry David N · Fairport, NYBuilt 1969 · S/N 15071196 N5698GKessler Frank J Jr · Gallatin, TNS/N 15071198 N5702GRandolph-Graham Monica L · Roanoke, TXBuilt 1969 · S/N 15071202 N5718GSwietek Robert E · Grand Rapids, MIBuilt 1969 · S/N 15071218 N5722GSchmitt Rudy · Bulverde, TXBuilt 1969 · S/N 15071222 N5724GCrnic John F · Kirksville, MOBuilt 1969 · S/N 15071224 N5736GGagana Aviation LLC · Leander, TXBuilt 1969 · S/N 15071236 N5740GAdventist World Aviation · Wilson, NCBuilt 1969 · S/N 15071240 N5745GPettis Gary D · Lula, GABuilt 1969 · S/N 15071245 N5748GKozar Theodore · Connellsville, PABuilt 1969 · S/N 15071248

Back to Cessna 150K