Carrollton, TX
Registered aircraft · 56
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 = 'CARROLLTON' 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 = 'CARROLLTON' 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.
N101VAVelocity VELOCITY · S/N SFD 001N107RMGates Learjet 25D · S/N 362N1133KJames R Johnson JOHNSON RV-6 · S/N 21234N1181PTextron 525B · S/N 525B0687N120TCThunder & Colt Airborne Amer AX7-77 S1 · S/N 1869USAN12387Cessna 172M · S/N 17261961N1514ZBeech N35 · S/N D-6832N1709JPiper PA-28-140 · S/N 28-24118N177LABeech B200 · S/N BB1203N1MREmbraer Executive EMB-505 · S/N 50500552N20040Cessna 172M · S/N 17260953N201VVMooney M20J · S/N 24-0175N21140Cessna 182P · S/N 18261441N2116KPowrachute PC 2000 · S/N POW276AN240CSTextron T182T · S/N T18209140N2480GCessna 182B · S/N 51780N2591LCessna 172H · S/N 17255791N2673NCessna 140 · S/N 12931N30QABombardier BD-100-1A10 · S/N 20357N3223PBaker Curtis L LONG EZE · S/N 1181N3276SCessna 182G · S/N 18255776N337WRRaytheon Corporate Jets HAWKER 800 · S/N 258273N34154Cessna 177B · S/N 17701672N364GWCessna 172S · S/N 172S9364N3728ABeech V35B · S/N D-9084N3996KPiper PA-28-140 · S/N 28-23888N402HMRaytheon HAWKER 850XP · S/N 258782N465LHHylio HYL-150 · S/N 17906110383N4740ECessna 182R · S/N 18268264N4763GCessna 414 · S/N 414-0938N4828XCessna 150G · S/N 15064878N513CCCessna 560XL · S/N 560-5678N560SPCessna R172K · S/N R1722359N5627LAmerican AA-1 · S/N AA1-0027N5PRCirrus Design SR22T · S/N 10913N6154WCirrus Design SR22 · S/N 0632N62748Boeing A75N1(PT17) · S/N 75-2161N6352PPiper PA-24 · S/N 24-1462N6565NBellanca 14-19 · S/N 2018N6720ACessna 172 · S/N 28820N6964VMooney M20F · S/N 22-1331N732UJCessna T210M · S/N 21061782N74562Mooney M20B · S/N 1873N759KRobinson Helicopter R44 II · S/N 12492N77654Fairchild 24R-46 · S/N R46333N8039SNorth American T-28C · S/N 140578N80SPIsrael Aircraft Industries ASTRA SPX · S/N 131N8147APiper PA-32R-301 · S/N 32R-8013047N84CTPrice David D HELICYCLE · S/N 3-14-E2-16N8705NPiper PA-28-140 · S/N 28-25526
Back to Carrollton, TX