Skip to content

Registered aircraft · 1,447

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

N10455Cowden Ryan A · Everson, WABuilt 1973 · S/N 15074866 N10459Ender Richard M · Rye, NHBuilt 1973 · S/N 15074868 N10466Richards Matthew · Southaven, MSS/N 15074870 N10473Vincent Geoffrey M · Andover, KSBuilt 1973 · S/N 15074873 N10474Some Beech LLC · Bolivar, MOBuilt 1973 · S/N 15074874 N10478Van Winkle Nicolas A · Renton, WABuilt 1973 · S/N 15074877 N10483Tennant Michael D · Granite Falls, WAS/N 15074881 N10487Wonderboy Aviation LLC · Hollsopple, PABuilt 1973 · S/N 15074885 N10488Heller John S Sr · Jackson, WIBuilt 1973 · S/N 15074886 N10495Pacific Electro Mechanical Inc · Pearl City, HIBuilt 1973 · S/N 15074888 N10498Scoma Steven G · Rhome, TXS/N 15074890 N104KMMorrison Mitchell A · Forest, VABuilt 1970 · S/N 15072415 N10505Registration Pending · Effingham, ILRegistration pendingBuilt 1973 · S/N 15074894 N10507Pch Aviation LLC · Elmhurst, ILBuilt 1973 · S/N 15074896 N10509Mckenna Andrew J Sr · Waynesville, OHBuilt 1973 · S/N 15074897 N1050CCourser Ezra D · Columbiaville, MIBuilt 1973 · S/N 15074893 N10518Post Ryan · Carmichaels, PAS/N 15074900 N10524Putrakul Kobkit · London, KYS/N 15074902 N10548Scootair LLC · Alburgh, VTBuilt 1973 · S/N 15074908 N10557Parker Helicopter LLC · Watsonville, CABuilt 1973 · S/N 15074909 N10565Pribyl Cris M · Hennessey, OKS/N 15074912 N10568Buchner Mark L · Springfield, VABuilt 1973 · S/N 15074914 N10574Osterberg Douglas L · Neenah, WIBuilt 1973 · S/N 15074916 N10577Hatch Arthur S Jr · Mt Vernon, TXBuilt 1973 · S/N 15074917 N10592Pedrick William M · Dixon, CABuilt 1973 · S/N 15074919 N105ASJohnson Scott R · North Hampton, NHBuilt 1973 · S/N 15074786 N10604Bittner Vernon J · New Richmond, WIBuilt 1973 · S/N 15074922 N10615Tarr Sheryl L · Spokane Valley, WABuilt 1973 · S/N 15074925 N10617Kern Aviation LLC · Shafter, CABuilt 1973 · S/N 15074927 N10618Roundy Kamlah F · Monteview, IDS/N 15074928 N10621Brosh Cameron R · Loveland, COBuilt 1973 · S/N 15074930 N10628Warner Daniel D · Linden, MIBuilt 1973 · S/N 15074932 N10630Perez Juan Carlos · Miami Gardens, FLS/N 15074934 N10644American Flag Airlines Inc · Ft Lauderdale, FLBuilt 1973 · S/N 15074942 N10645Dearborn Edward M · Acworth, GAS/N 15074943 N10647Kosko Stanley G · Seattle, WAS/N 15074945 N10649Seaplane Adventures LLC · Cheyenne, WYS/N 15074947 N10651Wampler Matthew T · Valles Mines, MOBuilt 1973 · S/N 15074948 N10653Loftin Jamie B · Shreveport, LABuilt 1973 · S/N 15074950 N10658Craigmyle William R · Cooperstown, NYBuilt 1973 · S/N 15074952 N10661Colberg Sigurd E · Palmer, AKBuilt 1973 · S/N 15074955 N10663General Aircraft Services LLC · Pendleton, ORS/N 15074957 N10669Loeppky Neal K · Seminole, TXBuilt 1973 · S/N 15074962 N10679Samson Rene R · Lewiston, MES/N 15074968 N1067LCollins Gene William · Manassas, VABuilt 1973 · S/N 15074965 N10681Chickasha Wings Inc · Chickasha, OKBuilt 1973 · S/N 15074970 N10682Thomas Edward L · West Bend, WIBuilt 1973 · S/N 15074971 N10683Burton Ryne W · Astoria, ILBuilt 1973 · S/N 15074972 N10687Boatright William L · Colonial Beach, VABuilt 1973 · S/N 15074974 N10688Wilson Oscar O Jr · Kountze, TXFirst renewal noticeBuilt 1973 · S/N 15074975

Back to Cessna 150L