Paris, TX
Registered aircraft · 78
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 = 'PARIS' 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 = 'PARIS' 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.
N103GBeech D18S · S/N A533N108MAPilatus PC-6/B2-H2 · S/N 792N113SPCessna 182M · S/N 18259768N18429Beech F33A · S/N CE-937N1993JBalony Kubicek Spol S R O BB18E · S/N 2544N201TAMooney M20J · S/N 24-0291N202JAMooney M20C · S/N 2570N2044VBeech A36 · S/N E-1390N207ZCRaytheon A36 · S/N E-3360N2173GCessna 182A · S/N 51473N221DZDJI AGRAS T50 · S/N 63YBLAM0020017N222LCessna 320E · S/N 320E-0053N240DZDJI AGRAS T50 · S/N 63YBLA002001SN249SAMooney M20R · S/N 29-0267N2591EAeronca 7AC · S/N 7AC-6173N2608GChampion 7ECA · S/N 450N299ADOgden Aubrey D RV-8 · S/N 82352N29GCHankins Jimmy G TERCEL · S/N T&S F27017SN2RPPiper PA-23-250 · S/N 27-7754160N31596Powrachute PEGASUS · S/N A-310-PEGN3364ZDiamond Aircraft Ind DA 62 · S/N 62.C051N34731Cessna 177B · S/N 17701965N3594QCessna 172M · S/N 17261694N36256Taylorcraft DC-65 · S/N 4028N3646HPiper AEROSTAR 600 · S/N 6008568161245N3739RCessna 172H · S/N 17255539N375RMDehavilland DHC-2 MK. I(L20A) · S/N 1227N431AFCessna 182T · S/N 18281193N4431NCessna L-19E · S/N 24734N456GGCirrus Design SR22 · S/N 0896N45WJHankins Jimmy G LANCAIR IVPTP · S/N 174N4964DCessna 182A · S/N 51064N496LTTextron 525C · S/N 525C0444N50326Cessna 150H · S/N 15069229N527BHBeech 58 · S/N TH-1190N5391NPiper J3C-65 · S/N 13563N5394EBeech K35 · S/N D-5898N554TMBeech A36 · S/N E-2688N5611SBeech V35 · S/N D-8150N5767PPiper PA-24-250 · S/N 24-845N57AXAshby Dennis A ASHBY EXPER RV6 · S/N 051N5820BXag P150 MAX · S/N 1863F25182295480X91RN6267ZPiper PA-25 · S/N 25-332N62QPiper PA-28-235 · S/N 28-7210011N648TTTextron 208B · S/N 208B5408N649TTDassault MYSTERE-FALCON 50 · S/N 342N66643Cessna 180K · S/N 18052952N6679ABeech A36 · S/N E-2082N6734CBeech A45 · S/N GM-141N6ADPiper PA-12 · S/N 12-730
Back to Paris, TX