Skip to content

Registered aircraft · 1,447

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.

N11938Johnson William L · Middleburg, VAFirst renewal noticeBuilt 1974 · S/N 15075716 N11940Elkeberry Morgan T · Sycamore, OHBuilt 1974 · S/N 15075718 N11942Puls Kurt V · Valparaiso, INS/N 15075720 N11944Weed Ellen M · Gassaway, WVBuilt 1974 · S/N 15075722 N11946Solari Michael R · Gilroy, CABuilt 1974 · S/N 15075724 N11952Jones William Edward · Scottsdale, AZBuilt 1974 · S/N 15075730 N11953Sanchez Chayanne R · Apex, NCBuilt 1974 · S/N 15075731 N11957Kopecky Dawn D · Center, NDBuilt 1974 · S/N 15075735 N11959Quyser Adil · Edison, NJBuilt 1974 · S/N 15075737 N11962Aeroleasing Inc · Medford, ORBuilt 1974 · S/N 15075740 N11970Kiforishin Samuel · Westfield, MAS/N 15075748 N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749 N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752 N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423 N11YWBaldwin William E · Kula, HIBuilt 1970 · S/N 15072351 N1200GHartmann Kaiser Robert · New York, NYBuilt 1972 · S/N 15073901 N1203QMusick John Thomas · White Hall, ARBuilt 1971 · S/N 15072503 N1214QTalapanuri Gokul N · Austin, TXBuilt 1971 · S/N 15072514 N1218QSale Reported · Commerce City, COSale reportedBuilt 1971 · S/N 15072518 N1219QRedeemed Flying Corps Association · Oklahoma City, OKBuilt 1971 · S/N 15072519 N1223QAlbertson Alford L · Lemoore, CABuilt 1971 · S/N 15072523 N1224QEmprize LLC · Menasha, WIBuilt 1971 · S/N 15072524 N1231QMclin Robert J · Mays Landing, NJBuilt 1971 · S/N 15072531 N1232QPeres Kenneth V · Erie, PABuilt 1971 · S/N 15072532 N1233QReach For Skies LLC · San Antonio, TXS/N 15072533 N1236QRawareo LLC · Warsaw, MOBuilt 1971 · S/N 15072536 N1237QN37gd LLC · Fort Myers, FLBuilt 1971 · S/N 15072537 N1239QFleishauer John · Trona, CABuilt 1971 · S/N 15072539 N1241QFly Rite Aviation LLC · Fort Myers, FLBuilt 1971 · S/N 15072541 N1248QHeffernan Kasey C · Torrance, CAS/N 15072548 N1250QSantiago Luis R · Waller, TXBuilt 1971 · S/N 15072550 N1254QWeber Joel A · Goddard, KSBuilt 1971 · S/N 15072554 N1255QDrucker Jonathan · Spring Hill, FLBuilt 1971 · S/N 15072555 N1256QRose Kerry D · Liberal, MOBuilt 1971 · S/N 15072556 N1259QBuckles Ryan · Mont Belvieu, TXS/N 15072559 N1261QLeas Michael A · Bemidji, MNBuilt 1971 · S/N 15072561 N1262QSandford Graves M · Moberly, MOS/N 15072562 N1264QYeghikian Sarmen · Glendale, CABuilt 1971 · S/N 15072564 N1265QDumankskii Aviation LLC · Columbus, OHBuilt 1971 · S/N 15072565 N1267QWiltshire Henry C Jr · Plymouth, MABuilt 1971 · S/N 15072567 N1270QCessna 1270q Partnership · Glenside, PABuilt 1971 · S/N 15072570 N1279QCerrit LLC · Helena, MTBuilt 1971 · S/N 15072579 N1283QMacaruso Matthew H · Warwick, RIBuilt 1971 · S/N 15072583 N1284QHogan Resources Inc · Bedford Hills, NYBuilt 1971 · S/N 15072584 N1285QDavis Allen J · Weidman, MIBuilt 1971 · S/N 15072585 N1288QCahill Chad · Edmond, OKS/N 15072588 N1289QLong Jeffrey K Trustee · The Villages, FLBuilt 1971 · S/N 15072589 N1293QCoxwell James L · Midlothian, TXBuilt 1971 · S/N 15072593 N1294QKimmons Anthony J · Bogue Chitto, MSBuilt 1971 · S/N 15072594 N1296QFey Brian F · Waycross, GABuilt 1971 · S/N 15072596

Back to Cessna 150L