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.

N3155VHutchinson Kevin J · Poplar Grove, ILS/N 15076403 N3156VSchwartz Amy A · Chandler, AZBuilt 1974 · S/N 15076404 N3160VPoteet Eddie · Corsicana, TXBuilt 1974 · S/N 15076405 N3168VAirgo Inc · Cetralia, ILBuilt 1974 · S/N 15076407 N3175VDunaire LLC · Mechanicsburg, PABuilt 1974 · S/N 15076408 N3177VSmith Daniel P · St George, UTBuilt 1974 · S/N 15076409 N3189VMunn Julian · Spring, TXS/N 15076413 N3193VFly Sky Ads LLC · Manalapan, NJBuilt 1974 · S/N 15076414 N3216VTwo Dot Aircraft LLC · Kalispell, MTBuilt 1974 · S/N 15076424 N3221VDevaney Aviation Inc · Palm City, FLBuilt 1974 · S/N 15076426 N3231VDariz Natascha Y · Mount Laurel, NJFirst renewal noticeBuilt 1974 · S/N 15076431 N3237VTreetop Flying Circus LLC · Niceville, FLBuilt 1974 · S/N 15076434 N3240VAbston Alexandria P · Vancouver, WABuilt 1974 · S/N 15076436 N3247VHentschel Ernest J · Galloway, NJS/N 15076440 N3253VWilliams Cecil R · Clarksville, TNBuilt 1974 · S/N 15076443 N3254VRegistration Pending · Bolivar, MORegistration pendingBuilt 1974 · S/N 15076444 N3258VBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1974 · S/N 15076445 N3259VMaynard Richard L · Vilonia, ARBuilt 1974 · S/N 15076446 N325UKilo Fox Aviation LLC · Saint Joseph, MIBuilt 1974 · S/N 15076531 N3278VMathison John · Vancouver, WABuilt 1974 · S/N 15076448 N3299VChannel City Flyers Inc · Goleta, CABuilt 1974 · S/N 15076452 N3301VErhard Robert T · Granville, OHBuilt 1974 · S/N 15076453 N3313VAviation Enterprises Inc · Springfield, MOBuilt 1974 · S/N 15076457 N3314VCurtiss Steve L · Fortine, MTS/N 15076458 N3321VRegistered aircraftBuilt 1974 · S/N 15076462 N333ADRegistration Pending · Lynchburg, VARegistration pending, pending cancellationS/N 15078954 N333VBHumes Garrett D · Leesburg, FLBuilt 1975 · S/N 15076623 N3341VAreeckal Rejee · Mcallen, TXBuilt 1974 · S/N 15076467 N3343VVitale Paul P · Green Valley, AZBuilt 1974 · S/N 15076468 N3356VCavu Pilot LLC · Powell, TNBuilt 1974 · S/N 15076471 N3359VArcher Lee R · Redondo Beach, CABuilt 1974 · S/N 15076473 N3370VHolladay Aviation LLC · Jacksonville, FLBuilt 1974 · S/N 15076477 N3372VSimmons Robert J · Rising Fawn, GABuilt 1974 · S/N 15076478 N3376VHill Craig · Memphis, TNBuilt 1974 · S/N 15076481 N3377VGardner Terrence L · Pittsboro, NCS/N 15076482 N3384VNewby Aviation LLC · Pingree Grove, ILS/N 15076484 N3386VFrg III Inc DBA · Lincoln Park, NJBuilt 1974 · S/N 15076486 N3396VHarvey Christopher J · Port Leyden, NYBuilt 1974 · S/N 15076488 N3400VLanier Gary L · Bloomington, ILBuilt 1974 · S/N 15076490 N3413VNiles Air LLC · Concord, NCBuilt 1974 · S/N 15076493 N3421VNebbia Valter Della · Archer City, TXBuilt 1974 · S/N 15076498 N3424VDriscoll Christopher · Beaufort, SCBuilt 1974 · S/N 15076499 N3428VNordquist Alexandra · Wasilla, AKS/N 15076500 N3429VSowieja Gary D · Inver Grove, MNBuilt 1974 · S/N 15076501 N3453VJones Donald T Jr · Barrigada, GUBuilt 1974 · S/N 15076506 N3454VZimmer Bernard A · Waxhaw, NCBuilt 1974 · S/N 15076507 N3460VDegeorge Richard L · Cape Coral, FLBuilt 1974 · S/N 15076508 N3475VSatterlee Michael E · Clever, MOBuilt 1974 · S/N 15076513 N3478VGazsy William · North Bellmore, NYS/N 15076514 N3486VLiberty Aviation LLC · Henderson, NVBuilt 1974 · S/N 15076518

Back to Cessna 150M