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.

N7665UGazca Aaron Armando · Burgaw, NCS/N 15077791 N7668UMarchbanks William W · Hillsboro, ORBuilt 1976 · S/N 15077794 N7670UMatthews Christopher T · Gardnerville, NVS/N 15077796 N7674UBischoff Daniel C · Camano Island, WAS/N 15077800 N7675UWaite Trevor K · South Ogden, UTBuilt 1976 · S/N 15077801 N7676URhine Steven L · Vancouver, WABuilt 1976 · S/N 15077802 N7677UOrser Shana J · Kissimmee, FLBuilt 1976 · S/N 15077803 N7679UDebenedetto John · Northwood, NHBuilt 1976 · S/N 15077805 N767RWWhitt Robert L · Carolina Beach, NCBuilt 1977 · S/N 15079378 N7682UTech Flight Corp · South Hamilton, MAS/N 15077808 N7692UDaso Manuel Sebastian · Spring Hill, FLBuilt 1976 · S/N 15077818 N7693UPerkins Robert A · New Richmond, WIS/N 15077819 N7694UDanfelt Eric A · Bend, ORBuilt 1976 · S/N 15077820 N7697UFox Norman A · Maryville, TNBuilt 1976 · S/N 15077823 N7698ULudwig Edwin E · Stephens City, VAS/N 15077824 N76HVScholz Francis M · Atchison, KSBuilt 1976 · S/N 15078633 N76STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1975 · S/N 15077396 N7704UAllen Philip · Portland, ORBuilt 1976 · S/N 15077826 N770NAOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1975 · S/N 15077280 N774MDecker Royce B · Deridder, LABuilt 1977 · S/N 15079345 N7756UReid Wayne P Jr · Yucaipa, CAS/N 15077832 N7763UMarshall Michael S · Lincoln, CABuilt 1976 · S/N 15077835 N7765UCentral Ohio Soaring Association Inc · Marion, OHBuilt 1976 · S/N 15077837 N7767USkynet Aviation LLC · Cocoa Beach, FLS/N 15077838 N7768UFoothill Sport Aviation LLC · Cameron Park, CABuilt 1976 · S/N 15077839 N776SASopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1976 · S/N 15077884 N7794UFlying Colors Airparts Inc · Leesburg, FLBuilt 1976 · S/N 15077843 N7796UDemaagd Ross E · Middleville, MIBuilt 1976 · S/N 15077844 N7797UHutchison Ryan A · Etiwanda, CABuilt 1976 · S/N 15077845 N7801UDeli Rick L · Oshkosh, WIS/N 15077846 N7819ULott Tyler · Kenneth City, FLBuilt 1976 · S/N 15077849 N7867UGregersen Michael · Blackfoot, IDBuilt 1976 · S/N 15077851 N7881UN7881u LLC · Mcminnville, ORBuilt 1976 · S/N 15077854 N7887UShaner Ervin Craig · Willow Spring, NCBuilt 1976 · S/N 15077855 N7891UCessna 150 152 Fly In Foundation · Springfield, VABuilt 1976 · S/N 15077857 N7913UKashmir Air Inc · Somerset, NJBuilt 1976 · S/N 15077859 N7922UButler Brandon R · Redmond, ORBuilt 1976 · S/N 15077861 N7928UPerson John · Wichita, KSBuilt 1976 · S/N 15077865 N7932UShenandoah Aviators LLC · Rockingham, VAS/N 15077869 N7933UHub City Aviation Academy LLC · Lubbock, TXBuilt 1976 · S/N 15077870 N7971UHallstrom Curtis R · Barnesville, OHBuilt 1976 · S/N 15077873 N7991UAlternate Air Inc · Seattle, WABuilt 1976 · S/N 15077876 N7UTVolunteer Aviation Foundation Inc · Tullahoma, TNBuilt 1974 · S/N 15076100 N8036UUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1976 · S/N 15077879 N803DJLyle Chase Thomas · Greenbrier, TNBuilt 1976 · S/N 15078798 N8057UNantz William G · Raleigh, NCS/N 15077882 N8058USafer Jonathan · West Milford, NJBuilt 1976 · S/N 15077883 N8108UTimko Jacob E · Levittown, PABuilt 1976 · S/N 15077885 N8109UShisler James E · Oakwood, OHS/N 15077886 N8119URosenoff John D · Riverside, WABuilt 1976 · S/N 15077890

Back to Cessna 150M