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.

N1282YShewalter Nicholas · Frankfort, MIS/N 15059682 N1284YBeamer Enterprises LLC · Ada, OKBuilt 1962 · S/N 15059684 N1285TGonzalez Paul · Peachtree City, GABuilt 1962 · S/N 15059685 N1286YRamaswamy Gautam · Clearwater Beach, FLBuilt 1962 · S/N 15059686 N1292YCarbiener Ross E · Kewanee, ILBuilt 1962 · S/N 15059692 N150DTWatson Matthew L · Liberty, UTFirst renewal noticeBuilt 1962 · S/N 15059671 N150YATrans Atlantic Flight Support · Middletown, DENon-citizen corporation, flight hours not reportedS/N 59377 N1962DTowery Daniel T III · Dover, DEBuilt 1962 · S/N 15059673 N3236MManning Daniel E · Posen, MIS/N 15059532 N3543Jaws Air LLC · Gainesville, FLBuilt 1962 · S/N 15059488 N517RANason David F · Kent, WABuilt 1961 · S/N 15059375 N662SHRay Lonnie D · Murfreesboro, TNBuilt 1962 · S/N 15059641 N70RTCurtis Robert W · Sikeston, MOBuilt 1962 · S/N 15059628 N7251XCampbell Jennings R Jr · Bell, FLBuilt 1961 · S/N 15059351 N7257XBuckelew James E · Gulf Breeze, FLBuilt 1961 · S/N 15059357 N7259XRedtail LLC · Lafayette, COBuilt 1961 · S/N 15059359 N7260XCoutu Justin · Whitewater, COBuilt 1961 · S/N 15059360 N7267XJudge Eli A · Whitefish, MTBuilt 1961 · S/N 15059367 N7274XFuellner Sean L · Shelocta, PABuilt 1962 · S/N 15059374 N7276XEvv 150 LLC · Evansville, INBuilt 1961 · S/N 15059376 N7281XBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 15059381 N7285XDover Rod S · Goldendale, WABuilt 1961 · S/N 15059385 N7286XKillian James D · Oakwood, GABuilt 1961 · S/N 15059386 N7291XWaterman David K · Temple City, CAS/N 15059391 N7292XRasmussen Paul L · Walla Walla, WABuilt 1961 · S/N 15059392 N7299XPecoy Edward D · Lyons, NYBuilt 1961 · S/N 15059399 N7302XGlover Thomas · Marana, AZBuilt 1961 · S/N 15059402 N7303XBosch Kent D · Montevideo, MNBuilt 1961 · S/N 15059403 N7308XEsmond Emmett W · Seattle, WABuilt 1961 · S/N 15059408 N7316XMattson Nicholas R · Vail, AZBuilt 1961 · S/N 15059416 N7322XHogan Robert Leroy · Depew, OKS/N 15059422 N7323XBrandt Goetz K · San Jose, CABuilt 1961 · S/N 15059423 N7327XAreopagita Ronnel · Linden, NJBuilt 1961 · S/N 15059427 N7331XPorter H Tom · Columbia, MSS/N 15059431 N7334XElliott Frank F · Mojave, CABuilt 1961 · S/N 15059434 N7335XTowery Katy L · Dover, DES/N 15059435 N7338XSahagun Salvador G · Bothell, WAS/N 15059438 N7339XRenewed Inc · Tekamah, NEBuilt 1961 · S/N 15059439 N7340XKohut Robert J · Sag Harbor, NYBuilt 1961 · S/N 15059440 N7343XEnyart Patrick · Lindlakes, MNBuilt 1961 · S/N 15059443 N7344XOff LLC · Lonoke, ARS/N 15059444 N7345XStraytail150 LLC · Minneapolis, MNBuilt 1961 · S/N 15059445 N7349XYaksh Haley · Tampa, FLS/N 15059449 N7353XLopez Jhoan Steven · Miami, FLBuilt 1961 · S/N 15059453 N7354XMartin Veronica S · Dover, DEBuilt 1962 · S/N 15059454 N7355XNorman Robert Alan · Zanesville, OHBuilt 1962 · S/N 15059455 N7357XBurbeck Nathan J · Fort Bragg, CABuilt 1962 · S/N 15059457 N7359XLawson William L · Decatur, MIBuilt 1961 · S/N 15059459 N7360XHimwich Elizabeth W · Bethesda, MDBuilt 1962 · S/N 15059460 N7370XWilkerson Gale L · Paris, MOBuilt 1962 · S/N 15059470

Back to Cessna 150B