Skip to content

Registered aircraft · 1,446

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

N18199Forthman Scott Chance · Miami, FLBuilt 1972 · S/N 15073856 N18200Morristown Flying Service Inc · Talbott, TNBuilt 1972 · S/N 15073857 N18201Anderson William T · Pine Bluff, ARBuilt 1972 · S/N 15073858 N18202Flying Tomato Aviation LLC · Medina, OHBuilt 1972 · S/N 15073859 N18208Ivy James E · Alba, TXS/N 15073863 N18210Aircraft Construction Specialist Inc · Collinsville, OKBuilt 1972 · S/N 15073865 N18213Diek Mondo R · Stevenson, WABuilt 1972 · S/N 15073867 N18222Baxter Paul A · Logandale, NVBuilt 1972 · S/N 15073876 N18225Cosentino Allen P · Templeton, MABuilt 1972 · S/N 15073878 N18229Fluno John I · San Anselmo, CABuilt 1972 · S/N 15073882 N18233Geiger Kurtis · Visalia, CABuilt 1972 · S/N 15073886 N18234Nance David B · Quinton, VABuilt 1972 · S/N 15073887 N183ERMustang Sally Aviation LLC · Camden, SCBuilt 1972 · S/N 15073584 N18501Dunbar Stephen E Trustee · Broken Arrow, OKS/N 15073894 N18502Smith Stewart K · Samson, ALBuilt 1972 · S/N 15073895 N18503Asejo Emmanuel · Kaaawa, HIBuilt 1972 · S/N 15073896 N18505Webb Terrell W · Albemarle, NCBuilt 1972 · S/N 15073897 N18506Mc Carley Kendel · Tucson, AZBuilt 1972 · S/N 15073898 N18519Chrystall Shane · Marysville, OHBuilt 1972 · S/N 15073909 N18522Carr Scott · Bells, TXBuilt 1972 · S/N 15073911 N18524Alpha International Aircraft Inc · Lewes, DES/N 15073913 N18527Bundy Richard S · Little Egg Harbor, NJBuilt 1972 · S/N 15073916 N18531National Test Pilot School · Mojave, CABuilt 1972 · S/N 15073920 N18533Booth Donald V · Denison, TXS/N 15073922 N18534Rupert Dinah J · New Plymouth, OHFirst renewal noticeBuilt 1972 · S/N 15073923 N18537Kirsch Richard D · Lisbon, NDBuilt 1972 · S/N 15073925 N18540Fisher Tracey R · Glenwood, IAS/N 15073928 N18546O'Sita Tade · Burnsville, MNFirst renewal noticeBuilt 1972 · S/N 15073934 N18552Malecha James L Trustee · Wilmot, NHBuilt 1972 · S/N 15073937 N18554Lavelle Jonathan A · Berrien Springs, MIBuilt 1972 · S/N 15073938 N18558Gunderson Robert B · League City, TXBuilt 1972 · S/N 15073941 N18565Hughes Danny R · Hickory, NCBuilt 1972 · S/N 15073946 N18567Barros Da Silva Norton · Tyler, TXBuilt 1972 · S/N 15073948 N18568Green Tom H · Vega, TXBuilt 1972 · S/N 15073949 N18569Doyle Harley M · O Brien, FLBuilt 1972 · S/N 15073950 N18572Stofka Joseph M · Erie, MIBuilt 1972 · S/N 15073952 N18574Reed Philip D · Millsboro, DEBuilt 1972 · S/N 15073954 N18578Nauerth John III · Lakefield, MNBuilt 1972 · S/N 15073956 N18579Beck Roger M Trustee · Goode, VABuilt 1972 · S/N 15073957 N18580Kirk Bryan · Las Vegas, NVBuilt 1972 · S/N 15073958 N18582Voigts Bruce M · Clarion, IABuilt 1972 · S/N 15073960 N18583Niles Donald W · Wadena, MNBuilt 1972 · S/N 15073961 N18584Murphey Julian Ryan · Knoxville, TNS/N 15073962 N18586Flyit LLC · Camas, WABuilt 1972 · S/N 15073964 N18587Payne Frederick B · Fayetteville, GABuilt 1972 · S/N 15073965 N18590Williams Michael · Williston, FLBuilt 1972 · S/N 15073968 N18594Robinson Ronald W · Saint Joseph, MIBuilt 1972 · S/N 15073970 N18596Baxter Wiley · Glennville, GABuilt 1972 · S/N 15073972 N18597Kiser Joshua Alan · Dry Ridge, KYS/N 15073973 N18598Gudgel Aviation · Lemoore, CABuilt 1972 · S/N 15073974

Back to Cessna 150L