Midlothian, TX
Registered aircraft · 184
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 = 'MIDLOTHIAN' 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 = 'MIDLOTHIAN' 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.
N10155Mooney M20S · S/N 30-0057N108MRRowe Mark A VANS RV-8 · S/N 81107N108PSPzl-Swidnik PW-5 · S/N 17.09.017N111WRJonker Sailplanes JS3 RES · S/N 03-189N115WEBeech 58TC · S/N TK-15N117GVSchempp-Hirth Flugzeugbau DUO DISCUS · S/N 181N118VUAmerican General Acft AG5B · S/N 10049N123VFFranklin Vernon Y VELOCITY SE-FG · S/N DMO-406N124RPCessna 152 · S/N 15282139N125PWPzl-Swidnik PW-5 · S/N 1705025N126KJCole Randall Kevin VANS RV9A · S/N 90265N1293QCessna 150L · S/N 15072593N130BNNeuner Robert W RV6 · S/N 20110N131CRConvair C-131B · S/N 53-7819N13400Cessna 172M · S/N 17262730N136PWPzl-Swidnik PW-5 · S/N 17.09.001N13VSSawyer David E RV-3 · S/N 723N142DWWalt George T VANS ACFT RV-4 · S/N 2449N144RMMartin C M/Harris R G RV-4 · S/N 2202Registration pendingN1491YCessna 172C · S/N 17249191N152PSCzech Sport PIPER SPORT · S/N P1001066N156DEElliott William Dennis VANS RV-7A · S/N 70967N15BRPiper PA-32R-300 · S/N 32R-7880004N161BLAero Commander 500-B · S/N 1551-197N163SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0525N164RFFrenzel Robert VANS AIRCRAFT RV-6 · S/N 60255N171CMMacarthur Craig RV-8 · S/N 82475N173SRCirrus Design SR22 · S/N 1925N1776KLuscombe 8E · S/N 4503N177TSCessna 177B · S/N 17702295N17907Schweizer SGS 1-26E · S/N 527N17SQGrumman American Avn. GA-7 · S/N GA7-0017N182XCessna 182P · S/N 18263344N1836XCessna 182H · S/N 18255936N1890MCessna 337G · S/N 33701490N18LFFalconi Louis J THORP T 18 · S/N 11N18MPManda Design MK-II · S/N 199N1948TPiper PA-28-140 · S/N 28-7125451N195MSCessna 195B · S/N 7994N1970MCessna A150L · S/N A1500300N201SEMooney M20J · S/N 24-1706-14N2040CBeech A36 · S/N E-1135N206DLBell 206L-3 · S/N 51170N2070RMooney M20M · S/N 27-0227N20JPBarchfeld J P BARCHFELD · S/N 783N22595Cessna 150H · S/N 15068389N227BESchleicher ASW-22BLE · S/N 22077N2280XStemme S-10 · S/N 10-27N228RWSud SA 318C · S/N 2114N2324DPiper PA-38-112 · S/N 38-79A0274
Back to Midlothian, TX