Skip to content

Registered aircraft · 976

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

N2977JBandy Suzanne M · Newport, ORS/N 15065777 N2978SRoach David · Modena, NYS/N 15066878 N2979JStygar Richard M · Coal City, ILBuilt 1966 · S/N 15065779 N2980JOrsak Eddie J · Seymour, TXBuilt 1966 · S/N 15065780 N2982JTijman Esteban M · Potomac, MDBuilt 1966 · S/N 15065782 N2982SHerzog Daniel L · Clinton, MIS/N 15066882 N2984JBell Edward A · Richfield, OHBuilt 1966 · S/N 15065784 N2985JScott Jason Eton · Seattle, WABuilt 1966 · S/N 15065785 N2986JWylam Thomas S · Ocala, FLBuilt 1966 · S/N 15065786 N2986SHouglan Norman L · Shepherdsville, KYBuilt 1967 · S/N 15066886 N2988JRegistration Pending · Asotin, WARegistration pendingBuilt 1966 · S/N 15065788 N2989JWright Brandon C · Cave City, KYS/N 15065789 N2990JHale Randall C · Bloomburg, TXS/N 15065790 N2990SAndresen Paul S · Chandler, AZS/N 15066890 N2991SVanbrocklin Valerie A · Anchorage, AKBuilt 1967 · S/N 15066891 N2992SN2992s LLC · Bristol, VTBuilt 1967 · S/N 15066892 N2993SCintron Jaime · Lake City, FLS/N 15066893 N2995SWillard Kevin C · Bartlett, NEBuilt 1967 · S/N 15066895 N2996JDziadaszek Daniel J · Yemassee, SCBuilt 1966 · S/N 15065796 N2996SKingdom Air Corp · Sutton, AKS/N 15066896 N2999SZheng Zheng · Walnut, CABuilt 1967 · S/N 15066899 N29NDDamstetter Katherine M · Hudson, FLS/N 15066888 N3005SSpennato Peter Jr · Rolling Hills, CABuilt 1967 · S/N 15066905 N3006SGrice Warren A · Marshall, ARBuilt 1967 · S/N 15066906 N3009SRegistration Pending · Arlington, TXRegistration pendingBuilt 1967 · S/N 15066909 N3012SMarshe Aviation LLC · Upland, CABuilt 1967 · S/N 15066912 N3013SRunge Robert H · Sidney, NEBuilt 1967 · S/N 15066913 N3016SBartholomew Dana C · Madison, WIBuilt 1967 · S/N 15066916 N3021SCollett Danny W · Stewart, TNBuilt 1967 · S/N 15066921 N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922 N3023SSynnes Dale C · Santa Paula, CABuilt 1967 · S/N 15066923 N3025SHummer Bryant C · Garden Plain, KSBuilt 1967 · S/N 15066925 N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926 N3029SBlawusch Richard K · Waterloo, WIBuilt 1967 · S/N 15066929 N3033SWelch Cara · Concrete, WABuilt 1967 · S/N 15066933 N3034SMore Development LLC · Tucson, AZBuilt 1967 · S/N 15066934 N3038SAbove All Aviation · Goleta, CABuilt 1967 · S/N 15066938 N3040SPearson Wayne L · Fayetteville, ARS/N 15066940 N3046SWhite William E · Watkinsville, GABuilt 1967 · S/N 15066946 N3047SBarrons Aviation Services LLC · Henderson, NVBuilt 1967 · S/N 15066947 N3048SFlight Expo Inc · Princeton, MNS/N 15066948 N3049SGenthner Scott A · Milo, MEBuilt 1967 · S/N 15066949 N3053SStelling Kurt · Newnan, GABuilt 1967 · S/N 15066953 N3057SMcabee Patrick A · Tampa, FLBuilt 1967 · S/N 15066957 N3062SRiver City Aviation LLC · Carmichael, CABuilt 1967 · S/N 15066962 N3063SLong Aaron T · Seguin, TXS/N 15066963 N3064SAtaee Behnam · Beatrice, NEBuilt 1967 · S/N 15066964 N3068SZephyrhills Flying Club Inc · Tampa, FLBuilt 1967 · S/N 15066968 N3072SRawson Aviation LLC · Pryor, OKBuilt 1967 · S/N 15066972 N3073SCresswell Aubrie J · Norwood, PABuilt 1967 · S/N 15066973

Back to Cessna 150G