Skip to content

Registered aircraft · 475

Aircraft with this engine 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 engine_model_code IN ('34801', '34802')
  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 engine_model_code IN ('34801', '34802')
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.

N630JTeufel Gregory W · Lake Stevens, WAS/N 497 N633JRose Peter Ian · Davie, FLBuilt 2008 · S/N 499 N633JWWhittington Robert Wayne · Blackwell, OKBuilt 2009 · S/N 001 N633LSDurbrow Richard A · Citrus Heights, CABuilt 2008 · S/N 04061738 N636JCcs Construction LLC · Canton, GABuilt 2008 · S/N 521 N637JShelton Amy · Bealeton, VAS/N 522 N641JHatfield Douglas · Avon, INBuilt 2008 · S/N 525 N642JSumrall Ben Jr · Mobile, ALBuilt 2008 · S/N 526 N644JBaxter Terry C · Garner, IABuilt 2008 · S/N 543 N644RBOtto David R · Saint Thomas, MOBuilt 2010 · S/N 757868 N645JWarner Ryan · Colville, WABuilt 2008 · S/N 544 N646JArrington Glenn · Toano, VABuilt 2008 · S/N 545 N648JWilliams Billy R H · Mesa, AZBuilt 2008 · S/N 546 N649JNunn Les · Pauls Valley, OKBuilt 2008 · S/N 547 N652TCCravy Marie A · Santa Maria, CABuilt 2011 · S/N 66763 N653BSchwaiger Richard T · Fort Wayne, INBuilt 2011 · S/N SS10XXXCOHK0539 N654JRegistration Pending · Jasper, GARegistration pendingBuilt 2008 · S/N 560 N657JStraub Stephen J · Ocean City, NJBuilt 2008 · S/N 561 N658JLawrence James D · Woodbridge, VABuilt 2008 · S/N 562 N6601XGreen Robert Christopher · Indianapolis, INBuilt 2012 · S/N 6-7173 N660JPhilly Sport Pilot LLC · Naples, FLS/N 563 N661JManor Jay Gerard · Broomfield, COBuilt 2008 · S/N 564 N664JLong Darrel Steven · Canaan, CTBuilt 2008 · S/N 572 N665JCamarata Timothy J · Renton, WAS/N 573 N667JLocascio Joseph M · Des Plaines, ILS/N 574 N668JClark Christopher · Salinas, CABuilt 2008 · S/N 575 N669KEcho Bravo Aviation LLC · Rapid City, SDS/N 1178 N671JChenoweth Michael F · Homestead, FLBuilt 2008 · S/N 576 N672JHungerford Richard M · Islamorada, FLBuilt 2008 · S/N 577 N673JSchuler Wanda S Trustee · Red Bluff, CABuilt 2009 · S/N 585 N674PJMurry Patrick A · Olathe, KSBuilt 2018 · S/N 0038 N675JKaspar Russell B · Frankfort, INBuilt 2008 · S/N 587 N679JBarber Rae S · Hinsdale, NHBuilt 2009 · S/N 588 N67WXBatten William A · Columbus, INBuilt 2025 · S/N WXB0067 N683DBSmith Matthew · Martinsville, INS/N 0691 N683JFunk Greg J · Greenville, SCBuilt 2009 · S/N 620 N687JKline Ronald · Finleyville, PABuilt 2009 · S/N 623 N688BCMcelveen Thomas G Jr · Springfield, GAS/N 00051 N688JSkendzel Gary · Oelrichs, SDBuilt 2009 · S/N 653 N689JStreet John P · East Durham, NYBuilt 2009 · S/N 624 N693JWare John G · Lamar, SCS/N 655 N695JMcclure Chris L · Tuscumbia, ALBuilt 2009 · S/N 659 N695PZRagan John L · Hayden, IDFirst renewal noticeBuilt 2010 · S/N 6-7366 N69601Starnes Michael T · San Antonio, TXBuilt 2009 · S/N 6-6871 N697JSuarez Javier · Riverside, CABuilt 2009 · S/N 661 N698JKirkpatrick Jordan L · Mount Vernon, ILBuilt 2009 · S/N 665 N698RALefebvre Richard · Rcho Sta Marg, CABuilt 2008 · S/N 524 N6997Poorman Alexander C · Angola, INBuilt 2010 · S/N 6375 N699JWoroniecki James N · Fremont, WIBuilt 2009 · S/N 666 N699SDHayden Lannis Shaun · Oakdale, LABuilt 2012 · S/N 1149

Back to Jabiru 3300