Skip to content

Registered aircraft · 1,065

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

N8773GWhite Jules W · Wichita, KSBuilt 1966 · S/N 15062873 N8779GEga Aero Specialty Services LLC · Beaufort, SCBuilt 1966 · S/N 15062879 N877ATAir One Inc · Valparaiso, INBuilt 1966 · S/N 15063724 N8785GPate Robert J · Hilltop Lakes, TXBuilt 1966 · S/N 15062885 N8786GKellum Roman Micah · Alexander City, ALS/N 15062886 N8786SJae Grace Elizabeth · Madison, ALBuilt 1966 · S/N 15062086 N8788GWagenaar Diane D · Frankston, TXBuilt 1966 · S/N 15062888 N8794SUS Flight Academy International Inc DBA · Post, TXBuilt 1965 · S/N 15062094 N8795GDesousa Raphael · Fremont, CABuilt 1966 · S/N 15062895 N8795SHuffman Jacob M III · Burleson, TXBuilt 1965 · S/N 15062095 N8796GSouthwest Texas Junior College · Uvalde, TXBuilt 1966 · S/N 15062896 N8796SSkylane Of Willmar LLC · Willmar, MNBuilt 1965 · S/N 15062096 N8798GMclemore Cecil E · Woodland, CAS/N 15062898 N8799SStroemsvik Kristian · Strasburg, VAS/N 15062099 N880Sanders Trent Trustee · La Canada Flt, CABuilt 1966 · S/N 15063567 N8800SMiedema Todd · Red Rock, TXBuilt 1965 · S/N 15062100 N8802SVan De Weert Steven G · Littleton, COBuilt 1965 · S/N 15062102 N8804GN8804g LLC · Edgefield, SCS/N 15062904 N8805GMazor Chris · Van Buren Twp, MIS/N 15062905 N8805SBatt Timothy D · Mc Grath, AKBuilt 1965 · S/N 15062105 N8807GHague Ryder S · Bradfordsville, KYS/N 15062907 N8808SReber Scott D · Newcastle, UTBuilt 1965 · S/N 15062108 N8809SJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1965 · S/N 15062109 N8810GSobers Dolton D A Jr · Caguas, PRBuilt 1966 · S/N 15062910 N8812SAnderson Benjamin J · Mondovi, WIBuilt 1965 · S/N 15062112 N8817SRomeo Tango Aircraft Holding LLC · Merritt Island, FLBuilt 1965 · S/N 15062117 N8819GGipson Aviation LLC · Winchester, TNBuilt 1966 · S/N 15062919 N8819SSmith Cory M · Naples, FLBuilt 1965 · S/N 15062119 N8820GMcdavid Bourke D Jr · Crestview, FLBuilt 1966 · S/N 15062920 N8822SRegistration Pending · Mishawaka, INRegistration pending, canceledBuilt 1965 · S/N 15062122 N8824GHarper Brian · Lake Jackson, TXBuilt 1966 · S/N 15062924 N8826GAlexander Jon D · Mohall, NDBuilt 1966 · S/N 15062926 N8830GSmokovitz Joseph M · Tecumseh, MIBuilt 1966 · S/N 15062930 N8832SSlad George W · Albuquerque, NMBuilt 1965 · S/N 15062132 N8834SNewlin Thomas R · Montezuma, INBuilt 1965 · S/N 15062134 N8835GNelson Joel B · Alliance, OHBuilt 1966 · S/N 15062935 N8835SWinchester Holdings LLC · Monticello, MNS/N 15062135 N8839GRegistered aircraftBuilt 1966 · S/N 15062939 N8840SBlue Thunder Aviation LLC · Heath Springs, SCBuilt 1965 · S/N 15062140 N8841GLinn Parker J · Brainerd, MNBuilt 1966 · S/N 15062941 N8842GTiller Stanford C · Loup City, NEBuilt 1966 · S/N 15062942 N8843GSanders Don · Mustang, OKBuilt 1966 · S/N 15062943 N8847GSabillon Luis H · Concord, CABuilt 1966 · S/N 15062947 N8849GSustarich Stephen M · Ketchikan, AKBuilt 1966 · S/N 15062949 N8850GSchool Board Of Seminole County Florida · Sanford, FLS/N 15062950 N8850SFlyers Park Farm LLC · Newark, OHBuilt 1965 · S/N 15062150 N8851SChamseddine Ahmed A · Middletown, RIBuilt 1965 · S/N 15062151 N8852GAmis Jan E · Weeki Wachee, FLS/N 15062952 N8855GAldrich Curtiss R · Big Oak Flat, CABuilt 1966 · S/N 15062955 N8856GMorris Charles K · Miami, FLBuilt 1966 · S/N 15062956

Back to Cessna 150F