Skip to content

Registered aircraft · 387

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

N100UDVogel Kelly C · Ventura, CAS/N 15070071 N103SGJared William C · Valparaiso, INBuilt 1958 · S/N 17004 N112LDMartin Joseph S · Carrollton, KYS/N 15076178 N112LNBruce James W · Searcy, ARBuilt 1972 · S/N 15073504 N1133YGreen Mountain Semiconductor Inc · Burlington, VTS/N 15059533 N118DHUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1960 · S/N 17937 N1200L1st American Aviation Inc · North Miami, FLBuilt 1959 · S/N 17785 N13588Headley Thomas J · Aptos, CAS/N 17074 N14084Chizek Terry L · Marion, KSBuilt 1960 · S/N 17944 N15060Palm View Aircraft Corp · Santa Rosa Beach, FLBuilt 1960 · S/N 17941 N150FMSanders Steven M · Powell, WYBuilt 1959 · S/N 17183 N180EFPoe Rick M · Mojave, CABuilt 1959 · S/N 17349 N180HPRobinson Michael D · Folkston, GABuilt 1959 · S/N 17381 N18328Kastler Richard S · Berkeley Springs, WVS/N 17728 N1959ERedsun Oren D · Fairfield, CAS/N 17450 N1969ZDownen David J · Murrieta, CABuilt 1962 · S/N 15059769 N201AAAdventures In The Sky Aviation LLC · Fresno, CABuilt 1959 · S/N 17352 N2044ZEddy Donald G · Ripley, NYBuilt 1963 · S/N 15059844 N2235JKnutson Wayne R · Thompson, NDS/N 150-65435 N26FSRenwick Andrew J · Senoia, GABuilt 1960 · S/N 17799 N271DTuckerman Kurt W · Branford, FLS/N 17801 N300KBBailey Stephen M Trustee · Lawton, OKBuilt 1960 · S/N 17970 N342HFWylie William E · Paxton, ILBuilt 1960 · S/N 17997 N344ENocera Frank J · Winder, GABuilt 1959 · S/N 17624 N3731DMond Darcee · Galena, ILS/N 17267 N377EPanepinto Lane P · Lafitte, LABuilt 1958 · S/N 17057 N399EFisher James W · Humboldt, TNBuilt 1959 · S/N 17219 N399STLankford Austin S · Sturtevant, WIBuilt 1959 · S/N 17399 N4156GSan Diego Community College District · San Diego, CAS/N 15078862 N4213UDemuri Daniel J · Woods Cross, UTS/N 15060213 N4279UEgolf Michael J · Cissna Park, ILBuilt 1963 · S/N 15060279 N4281UUS Flight Academy Intl Inc · Post, TXBuilt 1963 · S/N 15060281 N4357USilcott Robert W III · Fairview, OKS/N 15060357 N4382U82 Uniform LLC · Tremonton, UTS/N 15060382 N45DBMoler Doug · Valley Center, KSBuilt 1959 · S/N 17190 N46GMDeffner Gerhard Paul Heinrich · Mckinney, TXS/N 17235 N5501EMoffer Donley K · Grapevine, TXBuilt 1959 · S/N 17001 N5505EBarnwater Development Inc · Ardmore, OKBuilt 1958 · S/N 17005 N5507EFritsch Raymond H · Galesville, WIBuilt 1958 · S/N 17007 N5509EGifford Gary W · Lighthouse Point, FLBuilt 1958 · S/N 17009 N5514EBryan Andrew · Eureka, CABuilt 1958 · S/N 17014 N5515ENomad Pursuits LLC · Box Elder, SDBuilt 1958 · S/N 17015 N5517ETappenden Michael R · Coldwater, MIS/N 17017 N5520ECockerham Michael L · Ramseur, NCBuilt 1958 · S/N 17020 N5522EBauman Raymond Scott · Douglas, WYBuilt 1958 · S/N 17022 N5528EZook Kevin J · East Waterford, PABuilt 1958 · S/N 17028 N5529EKaono Jerry C · Carson, CABuilt 1958 · S/N 17029 N5532ETjs Holdings LLC · Dover, OHBuilt 1958 · S/N 17032 N5541ERoundy Steve G · Saint George, UTBuilt 1958 · S/N 17041 N5546ERosenthal John S · Bishop, CABuilt 1958 · S/N 17046

Back to Cessna 150