Skip to content

Bellanca 14-13-2

Registered aircraft · 77

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

N1413AKing John D · Midland, VABuilt 1947 · S/N 1532 N14396Tobias Eric · Milwaukee, WIBuilt 1947 · S/N 1509 N242Ohlmer Ted J · Monterey, CAS/N 1425 N29TJRegistration Pending · Bear Creek, PARegistration pendingBuilt 1946 · S/N 1174 N33GMMeulenberg Jacobus Mj · Schenevus, NYBuilt 1947 · S/N 1542 N413RPalmer Earl S · Lewiston, IDBuilt 1947 · S/N 1531 N427Olson Wesley M · Clovis, NMS/N 1364 N44FPShipman William L · Mc Calla, ALBuilt 1946 · S/N 1096 N73KVlk Mark J · Moses Lake, WABuilt 1947 · S/N 1154 N74212Hartman Dave · Miles City, MTS/N 1325 N74220Grzeskowiak Robert J · Tioga, NDS/N 1333 N74221South Carolina Aviation Museum Ltd · Wilmington, DEBuilt 1947 · S/N 1334 N74223Mid Atlantic Air Museum · Reading, PABuilt 1946 · S/N 1336 N74235Thorpe Brian J · Saint Augustine, FLBuilt 1946 · S/N 1348 N74257Norton John B · Colorado Springs, COBuilt 1946 · S/N 1370 N74266Stephenson Gary E · Philip, SDBuilt 1946 · S/N 1379 N74269Tanner Paul Leslie · Savoy, TXBuilt 1947 · S/N 1382 N74281Szostak Edward M · San Diego, CABuilt 1946 · S/N 1394 N74282Santana Joseph W · Waynesboro, VABuilt 1946 · S/N 1395 N74283Kelly Stephen M · Stonington, CTBuilt 1946 · S/N 1396 N74295Snavely William R · Lake Placid, FLBuilt 1946 · S/N 1408 N74297Williams David A · Whitewater, WIBuilt 1947 · S/N 1410 N74299Doe Gregory P · Smyrna, TNBuilt 1947 · S/N 1412 N74313Kraus Russell E · Albemarle, NCS/N 1426 N74314Dale John V · Sahuarita, AZBuilt 1947 · S/N 1427 N74337US Flight Academy International Inc DBA · Post, TXBuilt 1947 · S/N 1450 N74360Carboneau Luke · Las Cruces, NMS/N 1473 N74362Vlk Mark J · Moses Lake, WAS/N 1475 N74363Brewington Carl W · Roswell, NMBuilt 1947 · S/N 1476 N74364Brannon Lawrence A · Placentia, CABuilt 1947 · S/N 1477 N74372Smith Randall P · Ft Worth, TXBuilt 1947 · S/N 1485 N74376Vlk Mark J · Moses Lake, WABuilt 1947 · S/N 1489 N74378Goldschmidt Michael · Swanzey, NHBuilt 1947 · S/N 1491 N74380Allen Ken · Shelby, NCS/N 1493 N74384Record John · Perham, MEBuilt 1947 · S/N 1497 N74392Goodman William R · Opelika, ALBuilt 1947 · S/N 1505 N74411Schmidt Wilfred L · Elgin, ILS/N 1524 N74413Cullman Daniel H · Kent, WABuilt 1947 · S/N 1526 N74414Sherard Dale Edward · Marsing, IDBuilt 1947 · S/N 1527 N74424Hannagan Michael F · Endicott, NYBuilt 1947 · S/N 1537 N74428Tidd Jessica Marie · Reading, MIBuilt 1947 · S/N 1541 N74431Parsons John C · Wichita, KSBuilt 1947 · S/N 1544 N74445Vlk Mark J · Moses Lake, WAS/N 1558 N74450Nutter Michael S · University Place, WABuilt 1947 · S/N 1563 N74455Bell Joseph B · Tiffin, OHS/N 1568 N74466Weakley Byron D · Chapmansboro, TNBuilt 1948 · S/N 1579 N74467Anagnos Nick C · East Moline, ILBuilt 1948 · S/N 1580 N74474B & C Specialty Inc · Johnston, IAS/N 1587 N74490Wheeler Joellyn K · Collegedale, TNBuilt 1948 · S/N 1603 N74497Walentoski Gary E · Baytown, TXFirst renewal noticeBuilt 1948 · S/N 1592

Back to Bellanca 14-13-2