Skip to content

Registered aircraft · 72

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

N150HATmstar Services LLC · Lewes, DEBuilt 1969 · S/N A1500100 N324FFMason Michael A · New Carlisle, INBuilt 1969 · S/N A1500142 N482ALKcantarano LLC · Mulkilteo, WAS/N A1500223 N50TLSmith Lynn D · Roosevelt, UTBuilt 1970 · S/N A1500203 N5900JAir America LLC · Sioux Falls, SDS/N A1500200 N5906JErkie Norman R · Denison, TXS/N A1500206 N5918JStansfield Carl B · Springdale, UTS/N A1500218 N5919JFiles Richard W · Yuma, AZBuilt 1970 · S/N A1500219 N5958JHaymond Robert · San Antonio, TXBuilt 1969 · S/N A1500026 N773WSPerez Valentino · Sinajana, GUBuilt 1969 · S/N A1500058 N8305MGossage Terrence L · Port Angeles, WABuilt 1969 · S/N A1500005 N8310MFlying Engineers Inc · Indianapolis, INBuilt 1969 · S/N A1500010 N8314MDavid Ari C Esq Trustee · San Diego, CABuilt 1969 · S/N A1500014 N8323MBean Danny O · Mulkeytown, ILBuilt 1969 · S/N A1500023 N8324MKnox John D · Broken Arrow, OKBuilt 1969 · S/N A1500024 N8327MArch Frederick W Jr · Lake Placid, FLBuilt 1969 · S/N A1500027 N8328MLuker Victor R Jr · Terrell, TXS/N A15000028 N8336MStarz Align Aviation LLC · Marshfield, WIBuilt 1969 · S/N A1500036 N8340MBlake Larry Q · Suwanee, GABuilt 1969 · S/N A1500040 N8341MKab Aviation LLC · Cassopolis, MIBuilt 1969 · S/N A1500041 N8342MStreeter Wyatt E · Hanford, CABuilt 1969 · S/N A1500042 N8343MDuke Kay L · Darrouzett, TXBuilt 1969 · S/N A1500043 N8345MBryant William G · Kenai, AKS/N A1500045 N8349MMarker Nathan E · Amherst, OHBuilt 1969 · S/N A1500049 N8351MWheaton Eric J · Gig Harbor, WAS/N A1500051 N8352MOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1969 · S/N A1500052 N8355MRcs Services LLC · California, MDBuilt 1969 · S/N A1500055 N8356MSporie George F · Marinette, WIBuilt 1969 · S/N A1500056 N8360MOld Goat Aviation LLC · Naples, FLBuilt 1969 · S/N A1500060 N8364MComchoc Paul R · Bellevue, WABuilt 1969 · S/N A15000064 N8366MMccauley Aviation Inc · Springfield, TNBuilt 1969 · S/N A15000066 N8367MConner Jacob P · Kaplan, LABuilt 1969 · S/N A1500067 N8370MLandry Paul G · Fallon, NVS/N A1500070 N8371MNosewheels Navy LLC · Rochester Hills, MIBuilt 1969 · S/N A1500071 N8373MBond Hiram E · Pls Vrds Est, CABuilt 1969 · S/N A1500073 N8376MPhillips Lester L · Pahrump, NVS/N A1500076 N8377MBoyd Edward Lee · Apison, TNBuilt 1969 · S/N A1500077 N8378MKuklo Robert M · Livermore, CABuilt 1969 · S/N A1500078 N8383MKessler Aviation LLC · Lansing, WVBuilt 1969 · S/N A1500083 N8384M1st Clev-Mar LLC · Gainesville, TXBuilt 1969 · S/N A1500084 N8389MTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1969 · S/N A1500089 N8393MPatterson Robert A · Hillsboro, ORBuilt 1969 · S/N A1500093 N8395MJuliet Foxtrot Aviation LLC · Camden, SCBuilt 1969 · S/N A1500095 N8396MManley Steven T · Dallas, TXBuilt 1969 · S/N A1500096 N8398MHale Richard W · Warminster, PABuilt 1969 · S/N A1500098 N8402MBurke Shawn T · Flowery Branch, GABuilt 1969 · S/N A1500102 N8404MMitchell Ryan G · Ventura, CABuilt 1969 · S/N A1500104 N8407MJohnson Michele J · Buena Vista, COBuilt 1969 · S/N A1500107 N8410MJr Imaging Logistics Inc · Pasco, WAS/N A15000110 N8411MGroce Austin L · Lebanon, TNS/N A1500111

Back to Cessna A150K