Plano, TX
Registered aircraft · 181
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 = 'PLANO' 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 = 'PLANO' 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.
N1014Vans RV-12IS · S/N 12186N10385Schweizer SGS 1-26C · S/N 119N103CCPiper PA-28RT-201 · S/N 28R-7918055N103MJSwick J N/Swick M R SWICK-T · S/N S-10N103TRSwick James N SWICK T · S/N STRN1049DReims CESSNA FT337GP · S/N 0015N10MXIar Sa Brasov IAR 823 · S/N 76N1129UCessna 172M · S/N 17266858N114EBBeam Edward A VANS RV-14A · S/N 140636N1191ZAmerican General Acft AG5B · S/N 10023N120LBLindstrand Balloons 120A · S/N 5234N127QRBeech 300LW · S/N FA-146N136BABeech 35-33 · S/N CD-44N1387QCessna 150L · S/N 15072687N1409LBeech A23 · S/N M-798N15031Cessna T206H · S/N T20608725N1506QCessna 150L · S/N 15072806N150GHOtto Gregory A VELOCITY-FIXED GEAR · S/N DM0150N150KCCessna 150L · S/N 15074254N1574XPiper PA-28R-200 · S/N 28R-7535338N16130Stinson SR-7B · S/N 9693N174GFCessna 172R · S/N 17280532N17RLLacasse Roger A VARIEZE · S/N 635N18253Beech A36 · S/N E-1067N1830EChampion 7EC · S/N 7AC-5397N1850FBeech E-55 · S/N TE-1195N19411Mooney M20F · S/N 690085N1952TPiper PA-28R-200 · S/N 28R-7135185N19947Cessna 172M · S/N 17260877N199DWBeech E-90 · S/N LW-338N2013YCessna 172C · S/N 17249513N201KKMooney M20J · S/N 24-0450N20325Canadian Car & Foundry HARVARD IV · S/N CCF4-116N2095PPiper PA-23 · S/N 23-683N2138FPiper PA-32RT-300T · S/N 32R-7987065N214JDDonaldson Norman J VANS RV-6 · S/N 20416N2177EAeronca 7AC · S/N 7AC-5751N2191DBeech D35 · S/N D-3538N222RKBellanca 7KCAB · S/N 448-74N22QUBeech 1079 · S/N EB-14N241KDReiter Kenneth L COZY III · S/N 162N24829Piper J4A · S/N 4-742N2484NPiper PA-38-112 · S/N 38-79A0865N24HWright Thomas J Q-2 · S/N 2235N2513BAeronca 7CCM · S/N 7CCM-82N2582PTextron G36 · S/N E-4166N2597ZBellanca 7GCBC · S/N 1001-77N2644WMooney M20E · S/N 979N2705CScheibe L SPATZ-55 · S/N 591N2746CCessna 172R · S/N 17280587
Back to Plano, TX