Mcalester, OK
Registered aircraft · 26
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 = 'OK' AND g.registrant_city = 'MCALESTER' 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 = 'OK' AND g.registrant_city = 'MCALESTER' 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.
N113CKJacobs Donald RV6-A · S/N 22378N175VCCessna 175B · S/N 17556798N1925QCessna 177RG · S/N 177RG0325N210GMCessna 210L · S/N 21061393N236MKPiper PA-28-236 · S/N 28-7911321N2724WMooney M20C · S/N 3338N295DBButler Donald R RV-6A · S/N 21523N335HCJohansen Halvor U HATZ · S/N 022N425DVCessna 425 · S/N 425-0232N505WPZenith Acft ZODIAC 601 XL · S/N 6-4756N6025DCessna 182T · S/N 18281830N6264ACessna 182 · S/N 33064N71012Piper J3C-65 · S/N 18028N7121SCessna 182P · S/N 18265065N7271XCessna 182S · S/N 18280518First renewal noticeN738WLCessna 172N · S/N 17270293N7585SCessna 182Q · S/N 18265234N75TCirrus Design SR22T · S/N 9007N7879Glasflugel H 301 LIBELLE · S/N 24N7944CPiper PA-28-181 · S/N 28-7690091N85EVEvo Enterprises EVOLUTION · S/N EVO-0085N8706RR. J. Begin DSA-1 · S/N RJB-1N8741TCessna 182C · S/N 52641N915PPDJI AGRAS T20P · S/N 1581F5745234L0C1D02DN923PTCirrus Design SR22 · S/N 4531N98218Piper PA-28-140 · S/N 28-26114
Back to Mcalester, OK