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.

N5749GPorter John W · Center, TXBuilt 1969 · S/N 15071249 N5750GHolt Wayne A · Waterford, MEBuilt 1969 · S/N 15071250 N5757GWill Cutter G · San Angelo, TXBuilt 1969 · S/N 15071257 N5760GVan De Walle Matthew W · San Antonio, TXBuilt 1969 · S/N 15071260 N5765GQuiring Jason L · Terrell, NCS/N 15071265 N5768GBilton Nicholas J · Bozeman, MTBuilt 1969 · S/N 15071268 N5769GHarper William M Jr · Foley, ALBuilt 1969 · S/N 15071269 N5770GVoller Jim A · Strasburg, NDS/N 15071270 N5772GBean Dale R · Moreno Valley, CABuilt 1969 · S/N 15071272 N5774GHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071274 N5776GWilliams Timothy · Byron, GABuilt 1969 · S/N 15071276 N5777GZawtocki Ronald · Little Falls, NYBuilt 1969 · S/N 15071277 N5779GChapman Jeremy R · Niagara Falls, NYBuilt 1969 · S/N 15071279 N5780GAlvarez Faust M · Helena, MTBuilt 1969 · S/N 15071280 N5781GWilliams Lynwood A · Clayton, NCBuilt 1969 · S/N 15071281 N5785GBrown Colin M · Williamstown, NJBuilt 1969 · S/N 15071285 N5795GRhodes Tom B · Dallas, TXBuilt 1969 · S/N 15071295 N5799GBafa LLC · Lewes, DEBuilt 1969 · S/N 15071299 N5804GSkylands Air LLC · Port Orange, FLBuilt 1969 · S/N 15071304 N5808GMoncrieffe Ainsworth L · Aurora, COBuilt 1969 · S/N 15071308 N5811GBransky Camber · Griffin, GABuilt 1969 · S/N 15071311 N5814GEricson Eric · Saint Charles, ILBuilt 1969 · S/N 15071314 N5816GGwyn Devin R · Dallas, ORBuilt 1969 · S/N 15071316 N5817GWilliams James B · Bonifay, FLBuilt 1969 · S/N 15071317 N5818GCirri Joseph F · Deming, NMBuilt 1969 · S/N 15071318 N5819GBuchanan Jason A · Nampa, IDBuilt 1969 · S/N 15071319 N5821GMatthews Cheyenne B · Marion, IAS/N 15071321 N5822GRada Michael F · Eagan, MNS/N 15071322 N5824GNairways LLC · Dix Hills, NYS/N 15071324 N5825GAuxano Aviation LLC · Newark, DES/N 15071325 N5826GKingdom Art LLC · Cologne, MNS/N 15071326 N5827GHutchinson Linda M · Grass Lake, MIBuilt 1969 · S/N 15071327 N5828GSmith Joshua B · Kenai, AKS/N 15071328 N5830GDunn Michael J · Ozark, ARBuilt 1969 · S/N 15071330 N5832GFitzgibbon Patrick D · Waterloo, WIS/N 15071332 N5844GLummus David R · West Point, MSBuilt 1969 · S/N 15071344 N5845GBerg William J · Aberdeen, SDS/N 15071345 N5848GDerby City Aviation LLC · Vero Beach, FLBuilt 1969 · S/N 15071348 N5852GSwigart Davis Holdings Inc · Upland, CABuilt 1969 · S/N 15071352 N5853GJohnson Robert K · Monte Rio, CABuilt 1969 · S/N 15071353 N5857GWhitver Jeremy W · Ankeny, IABuilt 1969 · S/N 15071357 N5860GRegistered aircraftBuilt 1969 · S/N 15071360 N5864GScarabin Jim D · Apalachicola, FLBuilt 1969 · S/N 15071364 N5867GCrowley Kelly P · Mount Pleasant, SCBuilt 1969 · S/N 15071367 N5872GCramer John A · Marana, AZBuilt 1969 · S/N 15071372 N5877GClegg Stephen A · Port Orange, FLBuilt 1969 · S/N 15071377 N5883GDerry Delmar D · New Market, IABuilt 1969 · S/N 15071383 N5890GPommer Timothy J · Kittanning, PABuilt 1969 · S/N 15071390 N5891GWebb Christopher L · Burns, TNBuilt 1969 · S/N 15071391 N5896GYtsera Air Fred LLC · Lyndonville, VTBuilt 1969 · S/N 15071396

Back to Cessna 150K