Casper, WY
Registered aircraft · 1,207
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 = 'WY' AND g.registrant_city = 'CASPER' 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 = 'WY' AND g.registrant_city = 'CASPER' 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.
N10045Mooney M20R · S/N 29-0281N10053Boeing A75N1 · S/N 75-4986N100DCMolino PIK-20E · S/N 20008N100HRPiper PA-28-180 · S/N 28-4509N100VAEclipse EA500 · S/N 000138N100WMCirrus Design SR22 · S/N 1268N100WYCessna 175A · S/N 56439N101FKCirrus Design SR22 · S/N 3027N101JRRust Jim ACRO ONE · S/N R-1N101PQCessna 210B · S/N 21057932N101XNLorraine Morris N-3-2-W PUP · S/N N-3-2 #87N1023NPiper PA-18A · S/N 18-1889N1024LBeech 60 · S/N P-78N1026AMooney M20R · S/N 290321N102ARCirrus Design SR22T · S/N 0463N1033YCessna 172S · S/N 172S10598N103EYBeech A36 · S/N 1150N103RMCessna T310R · S/N 310R0109N1043HMooney M20TN · S/N 31-0058N104PCessna 182P · S/N 182-63801N105CCPiper/Cub Crafters PA-18-150 · S/N 9948CCN106LNew Piper PA-32R-301T · S/N 3257130N109RDDodge Douglas C DR 109 · S/N 001-PN109WRMesserschmitt BF109F · S/N 10256N109ZTAgusta A109C · S/N 7639N10FFCessna 421C · S/N 421C0082N10MCCirrus Design SR22 · S/N 1084N10RDCirrus Design SR22T · S/N 9300N1107QCessna 310H · S/N 310H0107N110ASWaco Classic YMF-F5C · S/N F5C110N110MAAviat A-1C-200 · S/N 3060N110WFCirrus Design SR22 · S/N 2621N1111XEmbraer-Empresa Brasileira De EMB-500 · S/N 50000245N111DVPiper PA 46-350P · S/N 4636311N111NWPiper PA-32R-300 · S/N 32R7680499N1122DCessna 140A · S/N 15686N1125XPiper PA-28R-200 · S/N 28R-7535251N112JARockwell International 112TCA · S/N 13182N113BPPiper PA 46-350P · S/N 4636363N113JSSullivin James GLASSAIR III SH3 · S/N 3134N114ATCommander 114-B · S/N 14619N114YMSocata TBM 700 · S/N 514N1165TBeech V35B · S/N D-9754N117CKCirrus Design SR22T · S/N 9480N118NHBeech F33A · S/N CE-1612N119HPPiper PA-28-140 · S/N 28-21570N119LWAgusta Aerospace AW119 MKII · S/N 14721N119WPAviat A-1A · S/N 1425N11JJCessna P210N · S/N P21000511N120MXCirrus Design SR20 · S/N 2281
Back to Casper, WY