Skip to content

Registered aircraft · 34

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

N102WBArtemis Inc · Hauppauge, NYBuilt 1968 · S/N 337M0104 N1041Del Rio Aviation Inc · Paso Robles, CAS/N 337M0317 N1102ALemon Gordon J · Edmond, OKS/N M3370377 N1141HMorris David · Hillsdale, MIBuilt 1967 · S/N 337M0013 N124DNRegistered aircraftS/N 337M0349 N18BBMuseum Of Flight Foundation · Seattle, WABuilt 1967 · S/N 337M0069 N1968AChristopher Chester F · Bay Saint Louis, MSBuilt 1973 · S/N M3370129 N21299L-Bird LLC · Hood River, ORBuilt 1967 · S/N 337-M0005 N302AZavoina Lawrence D Jr · Roanoke, TXBuilt 1969 · S/N 68-11055 N33702Hood Frank A · Burlington, NCBuilt 1967 · S/N 337M-0142 N370SDGreat Cloud Design Inc · Dunedin, FLNon-citizen corporation, flight hours not reportedBuilt 1969 · S/N 69-7659 N373AZFausel Cheryl A · Cape Coral, FLS/N 337M0079 N37566Aviation Specialty Services LLC · Beaufort, NCBuilt 1967 · S/N 337M0157 N409THQualitair LLC Trustee · MichelstadtS/N 337M0375 N427VKNichols Vikki J · Williamson, GABuilt 1967 · S/N 337M0133 N433KHHooey Kevin M · Corning, NYS/N 337M0139 N468DEUtah State University Space Dynamics Laboratory · North Logan, UTBuilt 1967 · S/N 337M0312 N48233Miller Robert S · Mesa, AZBuilt 1968 · S/N 337M0294 N502ABerry Darrel · Camden, TNBuilt 1969 · S/N 69-7617 N52575Crawford George T · Ocala, FLBuilt 1967 · S/N 337M0127 N5257JVra Leasing LLC · Beavercreek, OHBuilt 1967 · S/N 337M0116 N5258CRopkey Armor Museum · Indianapolis, INBuilt 1967 · S/N 337M0141 N5259WLauff Samuel J · Ocala, FLS/N 337MO196 N611MGIsr Platforms LLC · Mclean, VABuilt 1967 · S/N 337M0081 N626WBBorella Jay D · Bellingham, WAS/N 337M0440 N702AFTradewinds Aero Group LLC · Sarasota, FLBuilt 1967 · S/N 337M0108 N7146YRoberts George M · Houston, TXBuilt 1966 · S/N 337-M0399 N7200RDelk George H Jr · Roseland, VABuilt 1968 · S/N 337M0320 N802AShafer Robert · Grosse Ile, MIBuilt 1968 · S/N 337M0174 N815DRudy And Sylvia Airways LLC · Santa Monica, CAS/N 337-M0423 N86894Williamson K R · Bellefonte, PAS/N 68-6894 N87534Registered aircraftBuilt 1968 · S/N 337M0231 N9134QAviation Specialty Services LLC · Beaufort, NCBuilt 1968 · S/N 337-M0185 N976AWConnolly Luke A · Blaine, MNBuilt 1969 · S/N 337M0442

Back to Cessna M337B