Skip to content

Registered aircraft · 74

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

N4444CLester Chad M · New Castle, DEBuilt 1953 · S/N 16029 N4455CJohnson Kyle A · Cheshire, CTBuilt 1952 · S/N 7965 N4459CHankins Shannon G · Tulsa, OKBuilt 1953 · S/N 16044 N4498CGoettl Karl T · Clarkdale, AZBuilt 1953 · S/N 16082 N56WKarpik Joseph P · Floodwood, MNFirst renewal noticeBuilt 1952 · S/N 7952 N775RCummins Michael · Corona, CAS/N 7478 N9317ACunningham Kenneth R · Lawton, OKBuilt 1949 · S/N 7396 N9337AStich Michael T · Malvern, OHBuilt 1949 · S/N 7416 N9338APeck Darren K · Noblesville, INBuilt 1949 · S/N 7418 N9346AWilliams Darrell W · Fayetteville, ARBuilt 1949 · S/N 7425 N9359ABischof Timothy C · Saint Louis, MOS/N 7522 N9362AFoster Floyd W · Lyon, MSBuilt 1950 · S/N 7523 N9363AKincer Charles L · Richmond, MEBuilt 1949 · S/N 7442 N9365AGuntly David A · Franksville, WIS/N 7444 N9370AKeltz Bennie J · Hillsdale, INBuilt 1949 · S/N 7449 N9377AHawkins Bobby J · Greybull, WYBuilt 1949 · S/N 7456 N9387AMitchell Jeffrey S · Coldwater, OHBuilt 1949 · S/N 7466 N9398ATraver Larry L · Sturgis, SDBuilt 1950 · S/N 7477 N9829ARoy Rodney E DBA · Grand Marais, MNS/N 7508 N9848APearson Jeffrey W · Anaheim Hills, CABuilt 1950 · S/N 7541 N9851ARhoads Michael C · Ketchikan, AKS/N 7561 N9854ASchlichar James C · Austin, TXBuilt 1952 · S/N 7547 N9866AKellum Mark J · Belden, MSBuilt 1950 · S/N 7568 N9892AMiner Jay G · Seattle, WABuilt 1950 · S/N 7595

Back to Cessna 190