Chesapeake, VA
Registered aircraft · 148
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 = 'VA' AND g.registrant_city = 'CHESAPEAKE' 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 = 'VA' AND g.registrant_city = 'CHESAPEAKE' 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.
N100NKBeech D55 · S/N TE-767N1012GAmerican AA-1 · S/N AA1-0122N105MVFly Virginia Beach NORTHWING MAVERICK · S/N 001N106RRC2 Holdings 8 RV-8A · S/N 81263N10CNJones Cn/Jones CL VELOCITY XL-RG · S/N 3RX060N1104HPiper PA-28-140 · S/N 28-7725132N112MCCessna 305A · S/N 21071N120CTVans RV-12 · S/N 120173N12RFCessna 210A · S/N 21057612N1371JRockwell International 112A · S/N 371N14RZAlan Keith Butt CHALLENGER XL 65 · S/N CH2-0412-LSS-L65-0212N153RRPipistrel Italia S R L ALPHA TRAINER LSA · S/N 1103 AT 912 LSAN1708TPiper PA-28-140 · S/N 28-7125023N170BWBoeing PT-17 · S/N 75-8260N1805HPiper PA-32R-300 · S/N 32R-7780191N181AADJI PHANTOM 3 PROFESSION · S/N P76DCG21010529N193MECessna 172S · S/N 172S8458N202GHRobinson Helicopter R44 II · S/N 14202N2041PBeech F33A · S/N CE-821N2069YBeech 58TC · S/N TK-76N214MHCessna T206H · S/N T20608214N2172GPiper PA-32-300 · S/N 32-7940003N218RCAlexander Schleicher ASK 21 MI · S/N 211002N222BVCessna 172M · S/N 17264997N228BMCostruzioni Aeronautiche Tecna P2006T · S/N 391/USN2315WCessna 182T · S/N 18281948N23476Cessna 150H · S/N 15068976N249AFSchweizer SGS 1-26D · S/N 421N2668LCessna 172H · S/N 17255868N272HFTextron 172S · S/N 172S12776N272SBCessna 172S · S/N 172S8908N2730WMooney M20C · S/N 3429N27EBeech D17S · S/N 6883N28630Grumman American Avn. AA-5B · S/N AA5B0711N28SUExtra Flugzeugproduktions EA 300/L · S/N 1280N2987UCessna 172E · S/N 17250587N2LPCessna 680 · S/N 680-0219N30YDBoyd William E JR VANS RV-6A · S/N 23555N313RRPipistrel D O O ALPHA TRAINER · S/N 1205 AT 912 LSAN314PVTest Spol Sro TST-10M ATLAS · S/N 10010703N3215WPiper PA-32-260 · S/N 32-16N331ESRobinson Helicopter R44 · S/N 1067N353GSTextron 172S · S/N 172S12280N3626VCessna 150M · S/N 15076567N375BQQuery Bobby BUCKEYE DREAMMACHINE · S/N 001N382HFCzech Sport Aircraft A S SPORTCRUISER · S/N P1102012Registration pendingN3JJComp-Let Sroorganizacni Slozk TST-14 · S/N 14031809N40795Piper J5A · S/N 5-1180N408RRPipistrel D O O ALPHA TRAINER · S/N 1204 AT 912 LSAN414PHCessna 414A · S/N 414A0421
Back to Chesapeake, VA