Skip to content

Registered aircraft · 1,439

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

N6341KRiggin Flight Service Inc · Madison, SDBuilt 1975 · S/N 15077654 N63420Compton John · Jennings, LABuilt 1975 · S/N 15077301 N63423Hecht Jeffery W · Vassar, MIBuilt 1975 · S/N 15077304 N63424Luxaire Center Inc · Deland, FLBuilt 1975 · S/N 15077305 N63427Molitor John P · Hatfield, MABuilt 1975 · S/N 15077306 N63436Martino Aviation Inc · Rincon, GABuilt 1975 · S/N 15077312 N63437Registered aircraftBuilt 1975 · S/N 15077313 N6343KRegistration Pending · Fort Lauderdale, FLRegistration pendingBuilt 1975 · S/N 15077655 N63445Henderson John K Jr · Westport Island, MEBuilt 1975 · S/N 15077319 N63449Popescu Daniel · Nokesville, VABuilt 1975 · S/N 15077323 N63451Sterling James E · Smithville, TXBuilt 1975 · S/N 15077324 N63453Fischella Robert R Trustee · Tucson, AZBuilt 1975 · S/N 15077326 N63455Airspeed Jet Services LLC · Kirkland, WAS/N 15077328 N63460Kuck Russell W · Layton, UTBuilt 1975 · S/N 15077331 N63465Brandywine Flyers LLC · Malvern, PABuilt 1975 · S/N 15077336 N63469Herrera Jorge · Oxnard, CAS/N 15077339 N63471Rollison James · Scottsdale, AZS/N 15077340 N63472Meek Zachary C · Bradenton, FLBuilt 1975 · S/N 15077341 N63475Tmstar Services LLC · Lewes, DES/N 15077343 N63479Felix Larry J · Lafayette, INS/N 15077346 N63487Burkhardt Jessica D · Melbourne, FLBuilt 1975 · S/N 15077347 N63491Horseshoe Fliers LLC · Acton, MABuilt 1975 · S/N 15077348 N63496Pierce Matthew F · East Northport, NYBuilt 1975 · S/N 15077344 N6349KRoybal Michael A · Freeport, FLBuilt 1975 · S/N 15077658 N63500Johnson Lawrence F · Anchorage, AKBuilt 1975 · S/N 15077349 N63501Walters Daniel B · Hillsboro, MOBuilt 1975 · S/N 15077350 N63504Callahan Mfg Inc · Royal City, WABuilt 1975 · S/N 15077353 N63507Scudder Waylon B · Winona, MOBuilt 1975 · S/N 15077356 N63508New Joel H · Waco, TXBuilt 1975 · S/N 15077357 N63515Rivera Jaime · San Antonio, TXS/N 15077363 N63524New Garden Township · Landenberg, PABuilt 1975 · S/N 15077371 N63526Pollard Charles A · Eau Claire, WIBuilt 1975 · S/N 15077373 N63532Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 15077377 N63533Rue Levi G · Sheyenne, NDBuilt 1975 · S/N 15077378 N63543Turner Jeffrey L · Sour Lake, TXBuilt 1975 · S/N 15077382 N63547Puppy Dog Aviation LLC · Anchorage, AKBuilt 1975 · S/N 15077386 N63548Hoyle Jason · Grove, OKBuilt 1975 · S/N 15077387 N6354KAvenge Holdings LLC · Ashburn, VABuilt 1975 · S/N 15077660 N63550Reid Edwin T · Lake Charles, LABuilt 1975 · S/N 15077388 N63556Tietje Barry N · Elton, LABuilt 1975 · S/N 15077393 N6355KCiampa B Frank · Greenwood, INBuilt 1975 · S/N 15077661 N63565Cape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 15077398 N63575Christensen Koufax · Norman, OKBuilt 1975 · S/N 15077404 N63580Registration Pending · Newbury Park, CARegistration pendingBuilt 1975 · S/N 15077409 N63596Parke Helen M · Kent, WABuilt 1975 · S/N 15077416 N63598Hollrah Richard E · Enid, OKBuilt 1975 · S/N 15077417 N63599Burkel Robert G · Hemet, CABuilt 1975 · S/N 15077418 N6359KMaierhoffer Henry F DBA · Sylvania, GABuilt 1975 · S/N 15077662 N63605Lowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1975 · S/N 15077423 N63608Klug Brian V · Speonk, NYBuilt 1975 · S/N 15077425

Back to Cessna 150M