Skip to content

Cub Crafters PA18-150

Registered aircraft · 16

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

N113PJLang Carl · Harper, TXBuilt 2003 · S/N 9957CC N143CCAerial Messages Leasing Co · Longwood, FLBuilt 2003 · S/N 9956CC N146CCRegistered aircraftBuilt 2004 · S/N 9970CC N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CC N180ENNealey Eric D · Barrington, ILBuilt 2003 · S/N 9966CC N226JKSmith David C · Brewster, WABuilt 2004 · S/N 9965CC N324ALauridsen Hans O · Scottsdale, AZFirst renewal noticeS/N 9962CC N365CCSki Sawmill Family Resort Inc · Ulysses, PABuilt 2004 · S/N 9963CC N392CCCecil John P · Willows, CAFirst renewal noticeBuilt 2003 · S/N 9960CC N519WGThunderbird Photography LLC · Greenville, CABuilt 2003 · S/N 9964CC N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CC N5959KKilo-Kilo LLC · Wausau, WIBuilt 2004 · S/N 9972CC N65EJRobbins Lesley Linn · Bend, ORBuilt 2003 · S/N 9959CC N67XXLane Aviation Inc · Rosenberg, TXBuilt 2003 · S/N 9958CC N912SHamlin Edward D · Ward Cove, AKBuilt 2004 · S/N 9973CC N955DWWitham David · Sandpoint, IDBuilt 2004 · S/N 9969CC

Back to Cub Crafters PA18-150