Slidell, LA
Registered aircraft · 48
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 = 'LA' AND g.registrant_city = 'SLIDELL' 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.
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 = 'LA' AND g.registrant_city = 'SLIDELL' ORDER BY g.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.
N1232TPiper PA-28-140 · S/N 28-7225430N1424NPiper PA-24-260 · S/N 24-4383N145GBBehrens Gary K GLASAIR SH-2 · S/N 13206N15FPCessna 172N · S/N 17268574N1973RAmerican Legend AL18 · S/N AL-1237N201CGMooney M20J · S/N 24-0030N2316LBeech 23 · S/N M-142N295RPiper PA-34-220T · S/N 34-8133185N300DSHughes 269C · S/N 1140379N319TTLewko Wendell PELICAN PL · S/N 584N35448Piper J3F-65 · S/N 6353N3689JCessna 150G · S/N 15064989N3691NMooney M-20G · S/N 680038N38836Piper PA-28-181 · S/N 28-7790592N427DMBeech C90 · S/N LJ804N42JVBeech F33A · S/N CE-913N456WSCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC076N4574DBeech G35 · S/N D-4757N458DBRobinson Helicopter R44 II · S/N 14241N4726KCessna 182P · S/N 18263725N4761HPiper PA-11 · S/N 11683N500BBCessna 172D · S/N 17249768N51FGParker Robert G VANS RV8 · S/N 44-14400N54RTThomason Ricky Dale PULSAR XP · S/N 321N6151SCessna TR182 · S/N R18201629N64507Cessna 172M · S/N 17265267N7054VMooney M20F · S/N 22-1396N717MCPilatus Britten-Norman BN-2T · S/N C2112N72ALBeech D55 · S/N TE-584N741ESBeech A36 · S/N E-1915N7MCDehavilland DHC-6-100 · S/N 40N8020ZO'Connor William PAZMANY PL-4A · S/N 258N804DMLively Lanier D EARTHSTAR ODYSSEY · S/N DM01N809DMBeech E-90 · S/N LW-334N8394APiper PA-34-220T · S/N 34-8133114N8735PPiper PA-24-260 · S/N 24-4185N9028XCessna 182D · S/N 18253428N9071WPiper PA-28-235 · S/N 28-10671N910RBCessna 550 · S/N 5500267N9127ACessna 170A · S/N 18886N92363Piper J3C-65 · S/N 16822N9378LAmerican AA-1A · S/N AA1A-0078N9586UGrumman American Avn. AA-5A · S/N AA5A-0086N96805Taylorcraft BC12-D · S/N 9105N9714LBeech B19 · S/N MB-510N985MCBell Textron Canada 407 · S/N 54969N986MCDJI AGRAS T20 · S/N 4JBBJ3N001007JN98RLTextron 208B · S/N 208B5469
Back to Slidell, LA