Olive Branch, MS
Registered aircraft · 69
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 = 'OLIVE BRANCH' 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 = 'MS' AND g.registrant_city = 'OLIVE BRANCH' 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.
N1068FCessna 172N · S/N 17272943N10958Piper PA-28-181 · S/N 28020251N1276UCessna 172M · S/N 17266971N129SCessna 172M · S/N 17263118N13513Cessna 172M · S/N 17262810N1545WBeech 58 · S/N TH-1545N17065Cessna 150L · S/N 150-73615N172ESCessna 172K · S/N 17258019N1810DBeech C35 · S/N D-3079N20046Cessna 172M · S/N 17260959N221ACessna 172 · S/N 28413N252MTCessna 152 · S/N 15280407N255RFExtra Flugzeugbau EA 300/L · S/N 1326N269TUBeech 76 · S/N ME-95N26HTCessna 150M · S/N 15076177N2763DCessna 170B · S/N 25305N30TCessna 310G · S/N 310G-0031N3103MPiper PA-12 · S/N 12-1793N3212FMooney M20E · S/N 670005N36VPRaytheon A36 · S/N E-3584N3876CBeech B-60 · S/N P-513N451SRCirrus Design SR22 · S/N 2325N46188Cessna 172I · S/N 17257096N47856Cessna 152 · S/N 15283258N48400Cessna 152 · S/N 15283332N49471Cessna 152 · S/N 15281294N51376Cessna 150J · S/N 15069962N5233PCessna 152 · S/N 15284898N540SEStaudacher S 300 E · S/N 28N56355Piper PA-28R-200 · S/N 28R7335419N592HPCessna 150L · S/N 15075451N597JFPiper PA-28-181 · S/N 28-7890262N601WKZenith-Pearl ZODIAC CH601XL2 · S/N 6-6700N60397Cessna 172S · S/N 172S10227N60405Beech 76 · S/N ME-173N6105QCessna 152 · S/N 15285130N64413Cessna 172M · S/N 17265210N6512HCessna 172M · S/N 17265471N65VMCessna 525B · S/N 525B0034N6752ZBeech 76 · S/N ME-340N6753NMooney M20C · S/N 680067N68579Bellanca 7ECA · S/N 880-72N6953JPiper PA-32R-300 · S/N 32R-7680393N7132QCessna 172L · S/N 17260432N713RHBeech B200 · S/N BB-1274N7157GCessna 172K · S/N 17258857N727RLPiper PA-31-325 · S/N 31-7612056N72977Cessna 120 · S/N 10178N7409GCessna 172K · S/N 17259109N7537YPiper PA-30 · S/N 30-601
Back to Olive Branch, MS