Carlisle, IA
Registered aircraft · 31
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 = 'IA' AND g.registrant_city = 'CARLISLE' 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 = 'IA' AND g.registrant_city = 'CARLISLE' 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.
N126LEArbc Inc DBA Lindstrand 90A · S/N 5499N14AXAlon X-A4 · S/N 001N1517RFirefly Balloons FIREFLY 7-15 · S/N F7-2017N1852WBeech 58 · S/N TH-329N212JPPiros James G DR-107 · S/N 94-0159N215KBBalony Kubicek Spol Sro BB17XR · S/N 1367N2329CBalony Kubicek Spol Sro BB22XR · S/N 1127N2923Kubicek Factory S R O BB18XR · S/N 2387N31RRRegister Richard L CHRISTEN EAGLE II · S/N R-0001N336TXXag P100 PRO · S/N 1863FPEG8219352U73M0N348RPPiper PA-32-300 · S/N 32-7940186N3764FBalloon Works FIREFLY 6B · S/N F6B-011N401RGCirrus Design SR22T · S/N 10465N4038RBalloon Works FIREFLY 6B · S/N 6740N4157PGemini Industries GEMINI I · S/N 0063N421MTThunder Balloons AX7-77 · S/N 180N4450MXag P100 PRO · S/N 1863FPEG8219351770NJN4453MXag P100 PRO · S/N 1863FPEG8219351723CXN461JKBalony Kubicek Spol Sro BB20XR · S/N 631N462KBKubicek Factory S R O BB20XR · S/N 2144N504KBKubicek Factory S R O BB26AZ · S/N 2420N508KBKubicek Factory S R O BB20XR · S/N 2651N513GSArbc Inc DBA Lindstrand 60X · S/N 5440N515JCBalony Kubicek Spol Sro BB26E · S/N 1340N515KBKubicek Factory S R O BB18XR · S/N 2380N561KBKubicek Factory S R O BB18XR · S/N 2129N654JJKubicek Factory S R O BB30D · S/N 2130N7058KPiper PA-20 · S/N 20-165N71995Balloon Works FIREFLY 7-15 · S/N F7-1081N726GSArbc Inc DBA Lindstrand 65X · S/N 5692N777KCPiper PA-28-140 · S/N 28-7625239
Back to Carlisle, IA