Pineville, LA
Registered aircraft · 30
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 = 'PINEVILLE' 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 = 'PINEVILLE' 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.
N145BAThunder & Colt AX8-90 S2 · S/N 1132N16362Piper PA-28R-200 · S/N 28R-7335135N224JGCirrus Design SR22 · S/N 1013N232EZDassault FALCON 2000EX · S/N 232N2429UCessna 172D · S/N 17250029N2RJCirrus Design SF50 · S/N 0344N346SPCessna 172S · S/N 172S8268N364BTMarshall Robert L RV-6A · S/N 25621N377AGDassault FALCON 2000EX · S/N 032N41482Piper PA-28-151 · S/N 28-7415231N5075JPowrachute PEGASUS · S/N A 263 PEGN5219UCessna 172RG · S/N 172RG0287First renewal noticeN5261ZPiper PA-22-108 · S/N 22-8948First renewal noticeN53852Bellanca 7ECA · S/N 1129-76N5514PPiper PA-24 · S/N 24-577N553MACostruzioni Aeronautiche Tecna P92 ECHO SUPER · S/N 1044N600NKChesnut Bruce J KOLB SPORT 600 · S/N 769N60569Cessna 150J · S/N 15070411N62XTSkykits SAVANNAH VGW · S/N 11-03-51-833N6602NTaylorcraft BC12D-4-85 · S/N 3-13002N6616GCessna 150L · S/N 15072116Sale reported, pending cancellationN678TTWilliams James C JR TTN TNDO II MTR GLDR · S/N D99912SOHK0359N701UFU-Fly-It Light Sport Acft CHALLENGER II · S/N CH2-0305-2606N721RWPiper PA 46-350P · S/N 4636781N737ESCessna 172N · S/N 17269366N8825JPiper PA-28-180 · S/N 28-2780N9385JPiper PA-28-180 · S/N 28-3485N9491BCessna 175 · S/N 55291N99396Cessna 172P · S/N 17276441N9961ECessna 172N · S/N 17272300
Back to Pineville, LA