OpenAirDocs.org
Picayune, MS

Registered aircraft · 45

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'MS' AND g.registrant_city = 'PICAYUNE'
  ORDER BY g.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.

N11387Cessna 150L · S/N 15075376Built 1973 · Cloud Nine Aviation IncN139FWAgusta AB139 · S/N 31022Built 2005 · Chevron USA IncN14922Roncelli PL-4A · S/N 1-FRBuilt 1975 · Greulich Joseph NN188SAgusta A109A II · S/N 7349Hornet International LLCN18970Beech C23 · S/N M-1988Built 1977 · Wheatley Consulting LLCN206NYBell 206B · S/N 4069Built 1989 · Hornet International LLCN209JBLeonardo AW109SP · S/N 22454Built 2024 · Chevron USA IncN20ANLeonardo AW109SP · S/N 22453Built 2024 · Chevron USA IncN28373Bell 206B · S/N 1496Built 1974 · Hornet International LLCN292MHSikorsky S-92A · S/N 920204Built 2013 · Chevron USA IncN30PKIssoire Siren PIK-30 · S/N 719Built 1985 · Strand William CN31079Bell 206L-3 · S/N 51526Built 1991 · Top Flight Aviation Of Mississippi LLCN321DKCessna 182S · S/N 18280311Built 1998 · Twi Air LLCN3497RCessna 182L · S/N 18258797Built 1968 · Whitfield Derwin CN361DTBell 206-L4 · S/N 52080Built 1994 · 925dt LLCN392JSSikorsky S-92A · S/N 920249Built 2014 · Chevron USA IncN39LRBell Helicopter Textron 206L-1 · S/N 45654Built 1981 · Hornet LLCN445WHGill Tyrone GILL TURBINE MALIBU · S/N 001Built 2009 · Capital One Risk Management LLCN551JRPdps Pzl-Bielsko SZD-51-1 JUNIOR · S/N B-2000Built 1991 · Strand William CN558BVRaytheon B300 · S/N FL-223Built 1998 · Dt Air LLCN613LHBell 206L-3 · S/N 51594Built 1992 · Top Flight Aviation Of Mississippi LLCN613VJCirrus Design SR22T · S/N 11034Built 2025 · Dt Air LLCN639CFAgustawestland Philadelphia AW139 · S/N 41604Built 2025 · Chevron U S A IncN639DSAgusta Aerospace AW139 · S/N 41262Built 2011 · Chevron USA IncN639GGAgustawestland Philadelphia AW139 · S/N 41308Built 2012 · Chevron USA IncN639JKAgustawestland Philadelphia AW139 · S/N 41607Built 2025 · Chevron U S A IncN639MCAgustawestland Philadelphia AW139 · S/N 41288Built 2012 · Chevron USA IncN639MMAgusta Aerospace AW139 · S/N 41216Built 2009 · Chevron USA IncN639NAAgustawestland Philadelphia AW139 · S/N 41326Built 2013 · Chevron USA IncN639WWAgusta Aerospace AW139 · S/N 41229Built 2009 · Chevron USA IncN6533UBell 206L-3 · S/N 51439Built 1991 · Top Flight Aviation Of Mississippi LLCN71373Luscombe 8A · S/N 2800Built 1946 · Wilson Mikel WN7270QCessna 182S · S/N 18280484Built 1999 · Grey-Gc LLCN74439Grumman American Avn. AA-5B · S/N AA5B-0227Built 1975 · Costanza Frank VN7638MCessna 175 · S/N 55938Herbert-Johnson Veronica LN779RWRyan W Wuerz RV-14A · S/N 140200Built 2021 · Wuerz Ryan WN7857TCessna 172A · S/N 47457Built 1960 · Diamondhead Aero Co-Owners LLCN8532JCessna 150G · S/N 15066432Built 1967 · Werner Felix AN888EVHughes Helicopters 369E · S/N 0152EBuilt 1985 · Top Flight Aviation Of Mississippi LLCN895PCCessna T206H · S/N T20608892Built 2008 · 925dt LLCN903TWRaytheon B200 · S/N BB-1822Twi Air LLCN905MPCanadair CL-600 CHALLENGER · S/N 1039Built 1982 · Hornet International LLCN921GLSikorsky S-92A · S/N 920199Built 2013 · Chevron U S A IncN925DTEmbraer Executive EMB-505 · S/N 50500212Built 2014 · 925dt LLCN927SCSikorsky S-92A · S/N 920310Built 2019 · Chevron USA Inc
Back to Picayune, MS