Shreveport, LA
Registered aircraft · 276
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 = 'SHREVEPORT' 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 = 'SHREVEPORT' 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.
N1022MCessna 182P · S/N 18264209N102WKBeech F90 · S/N LA-36N10653Cessna 150L · S/N 15074950N106DDRaytheon C90A · S/N LJ-1738N1071SPiper PA46-500TP · S/N 4697298N10YBTeeters Larry N BEARHAWK · S/N 086N113JDEclipse EA500 · S/N 000081N117CHMesserschmitt BK 117 B-1 · S/N 7123N117NCEurocopter Deutschland MBB-BK 117 C-1 · S/N 7517N117UPEurocopter Deutschland MBB-BK 117 C-1 · S/N 7508N124WLCessna R172K · S/N R1723082N130EEEurocopter EC 130 B4 · S/N 7190N130HLCessna 414A · S/N 414A0322N130NBEurocopter EC 130 B4 · S/N 7221N13235Bellanca 14-19-2 · S/N 4050Registration pendingN134SWRaytheon 390 · S/N RB-81N135BUEurocopter Deutschland EC135P1 · S/N 0015N135DHEurocopter Deutschland EC135P1 · S/N 0133N135GFEurocopter Deutschland EC 135 P2+ · S/N 0249N136EHBeech A36 · S/N E-1555N137MHEurocopter Deutschland EC135P1 · S/N 0179N139MHEurocopter Deutschland EC135T2 · S/N 0330N1432JRockwell International 112A · S/N 432N143MHEurocopter Deutschland EC 135 P2+ · S/N 0613N145BUAirbus Helicopters MBB-BK 117 C-2 · S/N 9867N145CLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9188N145GFEurocopter Deutschland MBB-BK 117 C-2 · S/N 9209N151SPCessna 501 · S/N 501-0021N151WABeech B-60 · S/N P-423N152CABell 206B · S/N 2342N152UBeech 60 · S/N P-14N15379Piper PA-28R-200 · S/N 28R-7335053N156CABell 206B · S/N 1999N158BCEurocopter Deutschland EC135P1 · S/N 0134N18296Beech 58 · S/N TH-844N182JCCessna 182Q · S/N 18266621N182WVCessna 182J · S/N 18256971N18386Beech 58 · S/N TH-856N184SRSkyrunner MK 3.2 · S/N 0916C914MK32505007N197AABell 206B · S/N 3517N198LLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9158N198LSEurocopter Deutschland MBB-BK 117 C-1 · S/N 7537N1XDBeech N35 · S/N D-6702N1YWSiefker Ray Dean STRDSTR TOO SA-300 · S/N 00197N200DABeech B200 · S/N BB-1095N200UPEurocopter Deutschland EC135T1 · S/N 0089N206WABell 206B · S/N 3037N2165HPiper PA-28-181 · S/N 28-7990210N22173Aeronca 65-C · S/N C2759N2221GMooney M20M · S/N 27-0291
Back to Shreveport, LA