Skip to content

Registered aircraft · 111

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

N1102YSass James Louis Jr · Abilene, TXBuilt 1962 · S/N 15059502 N1109YKoller Keith S · Grosse Ile, MIBuilt 1962 · S/N 15059509 N1111YAeronautical Technical Service Inc · Collierville, TNBuilt 1962 · S/N 15059511 N1113YPrecision Design Inc · Weatherford, OKS/N 15059513 N1114YThompson Randy L · Anderson, CABuilt 1962 · S/N 15059514 N1121YShaw Michael B · Ridgeland, WIBuilt 1962 · S/N 15059521 N1127YWong David · Torance, CABuilt 1962 · S/N 15059527 N1128YPerez Donna · Chico, CABuilt 1962 · S/N 15059528 N1135YSwanson Isaac · Wasilla, AKS/N 15059535 N1140YPritchard Casey M · Bells, TXBuilt 1962 · S/N 15059540 N1144YThomas Douten D · Roxbury, MES/N 15059544 N1150YHoffman Anthony J · Rathdrum, IDBuilt 1962 · S/N 15059550 N1151YCraigmyle William R · Cooperstown, NYBuilt 1962 · S/N 15059551 N1157YMoles Dale A · Mooresburg, TNBuilt 1962 · S/N 15059557 N1158YAas LLC · Ovid, MIBuilt 1962 · S/N 15059558 N1159YAultman Micah · Rocky Face, GABuilt 1962 · S/N 15059559 N1162YBryan Danny J · Hobbs, NMBuilt 1962 · S/N 15059562 N1163YWyatt Airventures LLC · Ogallala, NEBuilt 1962 · S/N 15059563 N1166YPositive Painting Inc · Lakeland, FLBuilt 1962 · S/N 15059566 N1169YSkuza Patrick · Soldotna, AKBuilt 1962 · S/N 15059569 N1170YMacmullen Kenneth P · Quakertown, PAS/N 15059570 N1176YMay Jack R · Tallahassee, FLBuilt 1962 · S/N 15059576 N1183YCowan Ronnie C · Glasgow, KYBuilt 1962 · S/N 15059583 N1185YWilkerson Gale L · Paris, MOBuilt 1962 · S/N 15059585 N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596 N1200YMillner Jack A · Toledo, OHBuilt 1962 · S/N 15059600 N1203YWyatt G Whitlow · Wshngtn Ct Hs, OHBuilt 1962 · S/N 15059603 N1207YDickman Matthew J · Cold Spring, KYBuilt 1962 · S/N 15059607 N1208YSnyder Jason D DBA · Oakland, MDBuilt 1962 · S/N 15059608 N1211YEdens William D · Mesa, AZBuilt 1962 · S/N 15059611 N1212YKennedy Kevin · Vassar, KSBuilt 1962 · S/N 15059612 N1213YRistau Ronald R · Lu Verne, IABuilt 1962 · S/N 15059613 N1215YGill Robert S · Anchorage, AKS/N 15059615 N1222YPasseno Craig A · Cheboygan, MIBuilt 1962 · S/N 15059622 N1224YLowenkron Laurence H · Pleasanton, CABuilt 1962 · S/N 15059624 N1226YVolo Consulting LLC · Menomonee Falls, WIBuilt 1962 · S/N 15059626 N1227YGyure Ronald J · Ft Worth, TXBuilt 1962 · S/N 15059627 N1229YFinney James R · Howe, TXBuilt 1962 · S/N 15059629 N1233YPoland Marvin W · Tawas City, MIBuilt 1962 · S/N 15059633 N1237YLootens David P · Wofford Heights, CABuilt 1962 · S/N 15059637 N1238YGasman Aero LLC · Kalispell, MTBuilt 1962 · S/N 15059638 N1240YChanter Connor N · Grayslake, ILBuilt 1962 · S/N 15059640 N1246YMacy G Kevin · Brownsville, CABuilt 1962 · S/N 15059646 N1247YRogers Jacki-Lyn · Standish, MEBuilt 1962 · S/N 15059647 N1251YDurden Julian F Jr · Twin City, GABuilt 1962 · S/N 15059651 N1260YBoatright Michael L · Live Oak, FLBuilt 1962 · S/N 15059660 N1262YSatre Jeffrey A · Story City, IAS/N 15059662 N1264YWheeler Charles R · Crown Point, INBuilt 1962 · S/N 15059664 N1275YGrissom Patrick D · Blanco, TXBuilt 1962 · S/N 15059675 N1280YAutumn Crucus LLC · Cincinnati, OHS/N 15059680

Back to Cessna 150B