Skip to content

Registered aircraft · 756

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

N1016JRoberts Nettie R · Bowling Green, KYBuilt 1968 · S/N 15068595 N101DPStancy Marc A · Crystal Lake, ILBuilt 1967 · S/N 15067860 N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727 N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960 N10FPLoves Park Air LLC · Loves Park, ILS/N 15068636 N113NDFox Flight Instruction LLC · Jacksonville, FLBuilt 1967 · S/N 15067823 N11YSBonanza N5745v LLC · Colorado Springs, COBuilt 1968 · S/N 15068608 N130HJJaynes Grayson V · Burnet, TXS/N 15068617 N137ESWhobrey Andrew T · Bee Spring, KYBuilt 1967 · S/N 15067212 N150EWGlazier Matthew S · Presque Isle, MEBuilt 1968 · S/N 15068457 N150HRFeliciano Carlos A · Adjuntas, PRBuilt 1967 · S/N 15067248 N150NVAltom Chase S · Medford, ORBuilt 1968 · S/N 15069140 N150SWN W Aviators Inc · Troutdale, ORBuilt 1968 · S/N 15068868 N163LASimeon Sound LLC · Aguilares, TXBuilt 1967 · S/N 15067645 N192PMScheib Michael A · Dauphin, PABuilt 1967 · S/N 15067467 N1KBThibault Ryan D · Anchorage, AKBuilt 1967 · S/N 15067470 N209TOnele Dennis E · Central City, NES/N 15068531 N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000 N22003Hall David D · Des Moines, WAS/N 15068002 N22009Dundon Nick · Bozeman, MTBuilt 1967 · S/N 15068006 N22014Sun Valley Aviation Inc · Harlingen, TXBuilt 1967 · S/N 15068010 N22016Kiehle Ingrid E · Anchorage, AKS/N 15068012 N22019Swindell Daniel J · Greensburg, PABuilt 1967 · S/N 15068014 N22025Scheck Christopher R · Troutdale, ORBuilt 1967 · S/N 15068016 N22027Lyles Bobbi L · Broken Arrow, OKBuilt 1967 · S/N 15068018 N22029Youth Eagles Aviation · Elk Grove, CAS/N 15068020 N22037Johanson Jonas P · Groveland, CAS/N 15068023 N22039Barkan James · Las Vegas, NVS/N 15068025 N22049Air Carriage Inc · Chico, CAS/N 15068030 N22053Stoddard Greg E · Anchorage, AKBuilt 1967 · S/N 15068031 N22060Watson Thomas G · Sunderland, MAS/N 15068036 N22070Mcmullen Christopher · Holt, MOBuilt 1967 · S/N 15068043 N22076Glacier Flight Training LLC · Whitefish, MTBuilt 1967 · S/N 15068047 N22078Line Electric Company LLC · Lake City, FLBuilt 1967 · S/N 15068049 N22085Chandler Judd S · Corryton, TNBuilt 1967 · S/N 15068055 N22086Jackson Allan D · Wetumpka, ALS/N 15068056 N22090Aces Aviation LLC · Buffdale, UTBuilt 1967 · S/N 15068058 N22102Registration Pending · Metairie, LARegistration pendingS/N 15068063 N22106Andreu Kenneth J · Valhalla, NYS/N 15068064 N22110Schmitt Rudy · Brookshire, TXS/N 15068066 N22115Cummins Michael P · University Park, MDBuilt 1967 · S/N 15068069 N22123Hughes James H · Northlake, TXBuilt 1967 · S/N 15068074 N22128Sale Reported · Royal, ARSale reported, pending cancellationBuilt 1967 · S/N 15068077 N22129Morrison Dwayne L · Columbia, SCBuilt 1967 · S/N 15068078 N22130Kall Joseph F · Bozeman, MTBuilt 1967 · S/N 15068079 N22135Rosales Ruano Irving A · Plantation, FLS/N 15068084 N22138Obert Robert V · Dunnellon, FLBuilt 1967 · S/N 15068086 N22142Cummings Ezekiel · San Antonio, TXBuilt 1967 · S/N 15068090 N22145Mcdowell Jhonathon P · Lake Alfred, FLBuilt 1967 · S/N 15068093 N22146Star Voyages LLC · Kissimmee, FLBuilt 1967 · S/N 15068094

Back to Cessna 150H