Skip to content

Registered aircraft · 7,860

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

N7505LEichhorn David J · Corrales, NMBuilt 2001 · S/N 5182 N7505TRothrock Virgil N Jr · Streator, ILBuilt 1991 · S/N 5766 N7505ZGreenpeace Inc · Washington, DCBuilt 2002 · S/N 5218 N75065Carrasco Gregory A · Santa Fe, NMBuilt 1992 · S/N 5806 N7506HAz Air Ventures LLC · Safford, AZBuilt 1992 · S/N 5798 N7506QStell Gregory Paul · Tulsa, OKBuilt 2004 · S/N 5272 N7507WWooge Glen S · Swisher, IABuilt 2006 · S/N 5336 N7508AEscape Adventures Inc · Temecula, CABuilt 2004 · S/N 5258 N7509FDieringer Aaron J · Reno, NVBuilt 2003 · S/N 5240 N750LBAerosport Holdings Inc · Woodstock, GAS/N 5353 N750SHAer Blarney Balloons LLC · Bethlehem, CTBuilt 1992 · S/N 2896 N750WHMabee Bryant J · Apalachin, NYBuilt 2005 · S/N 5289 N7510AAdventures In Wicker Inc · Portage, MIBuilt 2003 · S/N 5243 N75135Pitoniak Michael · Townsend, MABuilt 1975 · S/N 35 N75154Breeze Air LLC · Henderson, TXBuilt 2005 · S/N 5316 N75167Seeger Kenneth A · Travelers Rest, SCBuilt 1992 · S/N 5815 N7516AHaynie Karen J · Mountain Home, TXBuilt 2005 · S/N 5305 N7516HFiller Joseph A · Bridgeton, NJBuilt 1992 · S/N 5812 N7517LPaul Alan D · Council Bluffs, IABuilt 1993 · S/N 5819 N7517SCourtney Bueno Neida E · Albuquerque, NMS/N 5796 N75180Farzad Dariush · Willseyville, NYBuilt 1992 · S/N 5773 N75181Vondruska Anne · Gardnerville, NVBuilt 2005 · S/N 5309 N75188Mumm Karalyn K · Reno, NVBuilt 1993 · S/N 5830 N7518EGallegos Joseph F · Los Lunas, NMBuilt 1992 · S/N 5827 N7518SHangar 505 LLC · Albuquerque, NMS/N 5784 N75192Roswell George A · Southbury, CTBuilt 1993 · S/N 5841 N7519BBrian R Chase · Moscow, PABuilt 1992 · S/N 5770 N7519NConrad Kenneth J · Albuquerque, NMBuilt 1992 · S/N 5816 N751DCNimbusciles · Germantown, TNBuilt 1978 · S/N 84 N7520LMorning Glory Balloon Tours LLC · Winthrop, WABuilt 1992 · S/N 5754 N7521LBroker William L · Frisco, TXBuilt 1993 · S/N 5848 N75222Finley J David · Driftwood, TXBuilt 1992 · S/N 5855 N7522YBlair Richard A · Pittsgrove, NJBuilt 1993 · S/N 5853 N7523AWooge Glen S · Swisher, IABuilt 2003 · S/N 5223 N7523FDoll Penny L · Roeland Park, KSBuilt 1993 · S/N 5854 N7523LBalloon Quest Inc · Fenton, MIBuilt 1993 · S/N 5856 N75245Henton Val W · Dodge City, KSFirst renewal noticeBuilt 1993 · S/N 5837 N7524AGreenwood Eric M · Albuquerque, NMBuilt 2003 · S/N 5228 N7524LMarttila Jonathan R · Kalamazoo, MIS/N 5852 N75250Degattis Colin · Sandia Park, NMBuilt 1992 · S/N 5786 N75259Dilibero Barry · Chester Springs, PABuilt 1992 · S/N 5829 N7525SSky Sports Inc DBA · Portage, MIBuilt 1992 · S/N 5781 N7527EKeefe Christopher M · Cross Plains, WIBuilt 2004 · S/N 5256 N7527SCygnet Leasing Company Inc · Columbus, OHBuilt 2004 · S/N 5259 N7529ARudy Walter R · Wadsworth, OHBuilt 2003 · S/N 5227 N752MJJurhill Molly Parker · Scottsdale, AZFirst renewal noticeBuilt 1988 · S/N F7-456 N7531Truckee Tahoe Soaring Association · Truckee, CABuilt 1970 · S/N 71 N7537Welch-Swett Theresa M · Zebulon, NCBuilt 1969 · S/N 167 N7539K&L Soaring LLC · Cayuta, NYBuilt 1970 · S/N 169 N753SHAero Force Balloons LLC · Simpsonville, KYBuilt 2018 · S/N 5666