Graham, TX
Registered aircraft · 42
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 = 'TX' AND g.registrant_city = 'GRAHAM' 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 = 'TX' AND g.registrant_city = 'GRAHAM' 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.
N1334WMooney M20E · S/N 222N1389HPiper PA-28R-201T · S/N 28R-7703024N2077CBeech C23 · S/N M-2074N2522APiper PA-22 · S/N 22-830N282BAFX CCX-1865 · S/N CCX-1865-2021Registration pendingN2868CCessna 170B · S/N 26411N3134GPiper L-18C · S/N 52-2419N322MRRaytheon C90A · S/N LJ-1611N33617Piper L-18C · S/N 52-2475N360MBCirrus Design SR22T · S/N 10360N3860RPiper PA-28-180 · S/N 28-5833N42257Piper J3C-65 · S/N 14507N4231RPiper PA-32-300 · S/N 32-40596N4786DCessna 182A · S/N 34886N5293HPiper PA-16 · S/N 16-97N531SHRobinson Helicopter R44 II · S/N 11346N555WHMorgan Darrell L RANS S-21 OUTBOUND · S/N 12180034N5601HPiper PA-16 · S/N 16-208N5664HPiper PA-16 · S/N 16-275N5852DPiper PA-22-150 · S/N 22-4531N5949HPiper PA-16 · S/N 16-573N5960ECessna 150 · S/N 17460N646Cirrus Design SR22T · S/N 9287N649SASymphony Aircraft Ind SA 160 · S/N S-0011N660ABBentley Alan F GLASTAR GS-1 · S/N 5660N66BRRowlandd THORP T-18 · S/N 983N710RVDaves Russell D RV-10 · S/N 40044N72453Beech A36 · S/N E-2265N728ZBZack Burkett MTOSPORT · S/N M01931N7433DPiper PA-22-150 · S/N 22-5197N7539EChampion 7FC · S/N 7FC-246N753LMBRM Aero S R O BRISTELL LSA · S/N 753-2024N76JHJoseph Hurst MTOSPORT · S/N M01981N7727QCessna 310Q · S/N 310Q0227N784DFArmstrong Walker R RAF 2000 GTX SS · S/N 001N789XETiahrt Rich RICH'S FLY BABY · S/N 504600638-1N850DKSocata TBM 700 · S/N 496N8868Bellanca 7ECA · S/N 931-73N91246Piper PA-18-150 · S/N 18-8209012N929PXSierra Flight AIR CAM · S/N AC-053N95SBTextron 525B · S/N 525B0581N99767Williams Ronald Wayne JR VANS RV-8A · S/N 81151
Back to Graham, TX