Skip to content

Registered aircraft · 122

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

N7198XScott Allexus D · Melbourne, ARBuilt 1961 · S/N 15059298 N7199XGrand Aviation LLC · Celina, OHBuilt 1961 · S/N 15059299 N7200XGloris Robert J · Lago Vista, TXBuilt 1961 · S/N 15059300 N7202XFielding John N · Scarborough, MEBuilt 1961 · S/N 15059302 N7206XChickasha Wings Inc · Chickasha, OKS/N 15059306 N7207XAbetz Jacob R · Tacoma, WABuilt 1961 · S/N 15059307 N7208XReese Scott D · New London, MNBuilt 1961 · S/N 15059308 N7209XSims Hollow M · Lithonia, GABuilt 1961 · S/N 15059309 N7210XStacey William B · Lebanon, TNBuilt 1961 · S/N 15059310 N7211XJenkins Joe C · Wyoming, DEBuilt 1961 · S/N 15059311 N7212XBurgess Sheldon · Raymond, MSBuilt 1961 · S/N 15059312 N7215XJackson Garrett J · Woodland, WABuilt 1961 · S/N 15059315 N7216XAmann David P · Wesley Chapel, FLBuilt 1961 · S/N 15059316 N7217XGorman Byron E · Knife River, MNBuilt 1961 · S/N 15059317 N7228XBrown Richard D · Woodward, OKBuilt 1961 · S/N 15059328 N7235XSpencer Tanya H · Coolidge, AZBuilt 1961 · S/N 15059335 N7240XGootee Gregory A · Anchorage, AKS/N 15059340 N7242XWatson Kenneth B · Sanford, TXBuilt 1961 · S/N 15059342 N7245XBelliveau Brian J · Easthampton, MABuilt 1961 · S/N 15059345 N7246XMuinos Jose M · York, PABuilt 1961 · S/N 15059346 N7247XGritter Robert C · Hudson, FLBuilt 1961 · S/N 15059347 N7249XZubeck Robert E · Emery, SDS/N 15059349

Back to Cessna 150A