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.

N222SADenny Robert C · Fort Myers, FLS/N 15078576 N2254FHudson Daryl J · Redwood Valley, CABuilt 1974 · S/N 15076160 N2259MHillabrand James E · Rogers, ARBuilt 1975 · S/N 15077090 N22638Lindorfer John H · Long Beach, MSBuilt 1976 · S/N 15078567 N255EWollak John M · Mount Vernon, WABuilt 1976 · S/N 15078149 N2609GRegistration Pending · Grove City, PARegistration pendingS/N 15077218 N2629YMayeko-Coklee Thomas · Lake Worth, FLS/N 15077311 N2655NLetourneau David W · Valencia, CABuilt 1976 · S/N 15077878 N26HTBluetail Aviation LLC · Olive Branch, MSS/N 15076177 N2810VDipasquale Glenn D · Gloversville, NYBuilt 1974 · S/N 15076288 N2814VCentral Ohio Soaring Association · Marion, OHBuilt 1974 · S/N 15076290 N2837VLewis Samuel Joseph · Decatur, TXBuilt 1974 · S/N 15076296 N2844VN2844 LLC · Riverton, UTBuilt 1974 · S/N 15076298 N2847VClinton Flying Service Inc · Clinton, NCBuilt 1974 · S/N 15076299 N2857VCiabattoni David E · Wallingford, PABuilt 1974 · S/N 15076302 N2866VLyles Ed · Newnan, GABuilt 1974 · S/N 15076304 N2872VRamirez Jose · Altadena, CABuilt 1974 · S/N 15076306 N2890VTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 15076313 N2891VSchaller Lee · New Athens, ILFirst renewal noticeBuilt 1974 · S/N 15076314 N2894VCuthbertson Steven M · Van Alstyne, TXBuilt 1974 · S/N 15076316 N2920VMorrow William M Jr · Harrison, IDBuilt 1974 · S/N 15076320 N2936VMurphy Julian Ryan · Knoxville, TNBuilt 1974 · S/N 15076327 N2945VMcclellan Stephanie · Hebron, ILS/N 15076330 N2950VCollins Robert J · Kennett Square, PABuilt 1974 · S/N 15076332 N2964VPlane Awesome LLC · Plymouth, MAS/N 15076335 N2966VBode Aviation Inc · Albuquerque, NMBuilt 1974 · S/N 15076336 N2977VKnott Brody · Camarillo, CABuilt 1974 · S/N 15076340 N3010VMurillo George A · Fremont, CAS/N 15076349 N301PFLahm David K · Cozad, NEBuilt 1975 · S/N 15076830 N3022VRetroair Restoration LLC · Big Lake, AKBuilt 1974 · S/N 15076354 N3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZS/N 15076355 N3028VChildress Sam · Weatherford, TXBuilt 1974 · S/N 15076357 N3029VFlyt LLC · Madison, MSS/N 15076358 N3030VSanders Flight Training Center Inc · Jasper, ALBuilt 1974 · S/N 15076359 N3039VMiller Zachary L · Roseau, MNBuilt 1974 · S/N 15076364 N3040VFlight Deck Air And Sea LLC · West Palm Beach, FLS/N 15076365 N3045VBuck Quincy M · Lakeville, MNBuilt 1974 · S/N 15076367 N3049VCraig Dennis M · Yukon, OKBuilt 1974 · S/N 15076369 N3051VMeyette Alexzander · Montague, MIBuilt 1974 · S/N 15076370 N3067VStauffer Todd · Jackson, MSBuilt 1974 · S/N 15076375 N3072VFlight Time Builders Inc · Memphis, TNBuilt 1974 · S/N 15076377 N3090VPinkepank James A · Peachtree City, GAS/N 15076380 N3103VN3103v LLC · Wheeling, ILBuilt 1974 · S/N 15076382 N3115VBarkman D Barry · Naples, FLBuilt 1974 · S/N 15076388 N3118VKemper Joseph C · Coxs Mills, WVBuilt 1974 · S/N 15076390 N3123VColemaker Aero & Marine LLC · Saint Augustine, FLBuilt 1974 · S/N 15076392 N3133VFluckiger Blaine W · Logan, UTBuilt 1974 · S/N 15076396 N3141VRenner Thomas J · Williston, NDS/N 15076399 N3143VWebb Hunter · Altonah, UTBuilt 1974 · S/N 15076401 N3148VConnor Gavin · Owensboro, KYBuilt 1974 · S/N 15076402

Back to Cessna 150M