Skip to content

Powrachute PEGASUS

Registered aircraft · 214

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 ('05901JZ', '0590008', '0690001', '05902PU', '060006F', '05902KW', '05622H0', '059024S', '05629M4', '05632L9', '05902CC')
  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 ('05901JZ', '0590008', '0690001', '05902PU', '060006F', '05902KW', '05622H0', '059024S', '05629M4', '05632L9', '05902CC')
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.

N105ABDawson Stephen A · Rio Vista, TXBuilt 2002 · S/N A-033 PEG N109PGCarkenord Aric L · Pharr, TXBuilt 2003 · S/N A109PEG N112WPPowell Wayne A · Waxahachie, TXBuilt 2004 · S/N A348PEG N117LBB13 Enterprises LLC · Joplin, MOBuilt 2005 · S/N A026ULS N1247KJabour Mufid · Denham Springs, LAS/N A-238-PEG N139SESahni Irvin K · Seguin, TXBuilt 2004 · S/N 9600 N140SEAchor James D · Converse, INS/N A-040PEG N142PGLarson Dennis K · Lake Elmo, MNBuilt 2003 · S/N A142PEG N1525MBridger Shawn D · Pocatello, IDS/N A312PEG N1661CStansbury Tony DBA · Rincon, GABuilt 2007 · S/N A435PEG N1753CDebord Ricky L · Taylorsville, KYBuilt 2003 · S/N A-008 PEG N1840CStamps Jeffery Scott · Mounds, OKBuilt 2005 · S/N A-363-PEG N1888HBrumfield Jeannie K · Afton, OKBuilt 2005 · S/N A414PEG N18901Stowe David C · Wilmington, ILBuilt 2005 · S/N A368PEG N1903YHarbert Bruce L · Frankston, TXBuilt 2005 · S/N A415PEG N192PDDeland Research Corp · Deland, FLS/N A115PEG N1999APerrachione John R · Kirksville, MOBuilt 2003 · S/N A-159PEG N2017YLeerhoff John Edward · Lewistown, MOS/N A-212-PEG N2029NGeiger Randal L · Fort White, FLBuilt 2002 · S/N A031PEG N20438Bruffett Chris L · Jasper, MOBuilt 2004 · S/N A290PEG N212GLCarvan Matthew R · Independence, MOBuilt 2002 · S/N A082 PEG N21ZXWalker Robert K · Cecil, ARS/N A318PEG N2225WRushing Patrice L · Apopka, FLS/N A427 PEG N244DLStout Donald C · Glenpool, OKS/N A-244-PEG N247RPPratt Randy J · Waynesville, MOBuilt 2006 · S/N A-211-PEG N2482URobison Russell S · Longmont, COBuilt 2002 · S/N A-073PEG N2498KGeorge Kevin J · Joplin, MOBuilt 2003 · S/N A 157 PEG N2498TRawlings Randy E · Alton, ILS/N A443PEG N2499CRodriguez Roberto J · Palmhurst, TXBuilt 2003 · S/N A-170PEG N2499SKunze Robert M · Muncie, INBuilt 2004 · S/N A344 PEG N25020Graves Charles L · Joplin, MOBuilt 2002 · S/N A-038 PEG N2541ZRegistration Pending · Humboldt, TNRegistration pendingBuilt 2005 · S/N A-359-PEG N2562VRedden Robert R · Utopia, TXBuilt 2002 · S/N A-070PEG N2566XRoberts Rolland J · Hanover, MIS/N A417PEG N2567NJackson Gideon T · Yoncalla, ORBuilt 2003 · S/N A-220-PEG N257XVanover Tony L · Marysville, CABuilt 2015 · S/N A511PEG N2608THemphill Charles E · Cleburne, TXBuilt 2007 · S/N A-447-PEG N2613RAnderson Tony K · Cleburne, TXS/N A251PEG N261YPMcconnell Martin · Carolina Beach, NCBuilt 2024 · S/N A520PEG N2620RDaffin Robert Vance III · New Waverly, TXBuilt 2004 · S/N A-279-PEG N2628MTipton William · Atoka, OKS/N A437PEG N2674EBaugh Caleb · Carthage, MOBuilt 2003 · S/N A 164 PEG N2731NFoster Phillip Fayne · Hallsville, TXBuilt 2004 · S/N A325 PEG N2742TPerdue Jason B · Carlisle, KYBuilt 2003 · S/N PEG 123 N2786AGardner Mark W · Wasola, MOBuilt 2003 · S/N A 131 PEG N2825WPelkey Richard L · Farmington, NHBuilt 2004 · S/N A-282-PEG N3023VFalkensten Richard F Trustee · Joplin, MOBuilt 2005 · S/N A268PEG N30248Larson Gregory R · Watertown, SDBuilt 2004 · S/N A 324 PEG N3040ACox Paul S · Nashville, ARBuilt 2003 · S/N A-210-PEG N30528Poper Jack D · Rensselaer, INBuilt 2003 · S/N A-140PEG

Back to Powrachute PEGASUS