Carlisle, PA
Registered aircraft · 40
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 = 'PA' 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 = 'PA' 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.
N1205Waring & Wells Airdrome TABLOID · S/N 002N170PKInxs SPORTSMAN GS-2 · S/N 7334N2134BBoeing B75N1 · S/N 75-6740N274LHReims CESSNA F177RG · S/N 0056N29DABeech 58 · S/N TH-645N29MSStill Michael J GLASTAR · S/N 5490N314KDCirrus Design SR22 · S/N 10165N315WTJeffrey A Nailor RANS S20 · S/N 03150039N31726Aeronca 65-TC · S/N F6110TN3186Hancock-Harris PITTS SPECIAL · S/N HH-1N35JNCirrus Design SR22T · S/N 9804N36619Piper PA-28R-201 · S/N 28R-7837286N369AMFox Alfred M ZENITH STOL CH 701 · S/N 7-11576N36JFRockwell International 690B · S/N 11478N37WRGreat Lakes 2T-1A-2 · S/N 0721N408RJJohnston Rex D HELO BANDIT · S/N R0447N433SALeading Edge Aerial Tech PV40X · S/N 11436N4399LCessna 172G · S/N 17254482N4441VCirrus Design SR22T · S/N 1758N4526XPiper PA-28-140 · S/N 28-7625049N4764MBeech F33A · S/N CE-782N494DCAdam Messer ZENITH CH701 · S/N 7-5430N5277LCessna T206H · S/N T20608399N5392KNavion NAVION B · S/N NAV-4-2292-BN5804WPiper PA-28-160 · S/N 28-1895N585DPPratt Donald G PRATT MXL2 · S/N 005N61MLClassic WACO YMF · S/N F5C-061N6341PCessna 152 · S/N 15285004N651PStill Michael J TITAN T-51 · S/N 055N714AJCessna 150M · S/N 15079024N7238FPiper PA-28-140 · S/N 28-25150N7718NPiper PA-28-180 · S/N 28-5027N8094RPiper PA-28-236 · S/N 28-7911325N8309MCessna 182P · S/N 18264587N906PPLeading Edge Aerial Tech PV40X · S/N 11466N9261HCessna 172M · S/N 17266054N92CKCessna P210N · S/N P21000160N9374LAmerican AA-1A · S/N AA1A-0074N9524LGrumman American Avn. AA-5 · S/N AA5-0524N9738ZBell 47D1G · S/N 57
Back to Carlisle, PA