Cleburne, TX
Registered aircraft · 58
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 = 'CLEBURNE' 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 = 'CLEBURNE' 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.
N1174BKirchoff Earl K BOWERS FLY BABY IB · S/N 73-17N120CWCessna 120 · S/N 8718N124MNBeech H35 · S/N D-5287N124ZXHarmenings High Flyers DELUXE · S/N 006098N1330YCessna 172C · S/N 17249030N1396RGrumman American Avn. AA-5 · S/N AA5-0796N153BAMaples Phillip M ZENITH 801 · S/N 880211N1802VCessna 172M · S/N 17263756N2014WDestiny XLT · S/N 4C-0585N202WDoody Robert M HUMMEL BIRD · S/N 5026N207ARMooney M20TN · S/N 31-0012N20NBalloon Works FIREFLY 7 · S/N F7-600N2355XCessna 182H · S/N 18256255N247XMacinnes James GLASAIR II S FT · S/N 2241N25002Thorp T-18 · S/N 257N2512QCessna 182K · S/N 18257712N2557APiper PA-22-135 · S/N 22-855N25677Swearingen SA-226T · S/N T-254N2597NCessna 140 · S/N 12857N2608TPowrachute PEGASUS · S/N A-447-PEGN2613RPowrachute PEGASUS · S/N A251PEGN2628SCessna 337C · S/N 337-0928N2901UCessna 172D · S/N 17250501N3105TCessna 177 · S/N 17700405N32439Piper PA-28-151 · S/N 28-7515156N36XCessna T210M · S/N 21061650N38970Piper PA-28-161 · S/N 28-7716302N430ZPPowrachute PEGASUS · S/N A486PEGN43228Taylorcraft BC12-D · S/N 6887N444CJRobinson Helicopter R44 II · S/N 14712N444JKPiper PA-23-250 · S/N 27-7854025N455EZIwatate Debbie LONG-EZ · S/N 455N5002BBeech F35 · S/N D4271N5007ACessna 172 · S/N 28007N515EKBeech B36TC · S/N EA-440N5250CBeech B35 · S/N D-2642N52DCMichael Norris/Chad Norris RANS S-21 · S/N 06200111N55SBeech D95A · S/N TD-631N5607RPowrachute AIR WOLF 912 · S/N A079ULSN562GHCirrus Design SR22T · S/N 11055N5660SBeech A23-19 · S/N MB-101N61VUCirrus Design SR20 · S/N 10811N6318TCessna TR182 · S/N R18201976N6409LAmerican AA-1A · S/N AA1A-0409N661VBeech 35-33 · S/N CD-83N704JCCessna 150M · S/N 15078639N70919Piper J3C-65 · S/N 17945N75110Piper PA-28-151 · S/N 28-7615251N786DJPiper PA-28-151 · S/N 28-7415358N787DJPiper PA-28-161 · S/N 28-7816014
Back to Cleburne, TX