OpenAirDocs.org
Hampton, VA

Registered aircraft · 73

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 = 'HAMPTON'
  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.

N102BTNasa Langley Research Center BAT-4 · S/N B4B009Nasa Langley Research CenterN114PWCommander 114-B · S/N 14542Siddiqu ShahidN1716ECessna T310R · S/N 310R1547Built 1978 · Mccaskill William LN2159BLuscombe 8E · S/N 6586Built 1949 · Rappa GiovanniN319MPCirrus Design SR22 · S/N 0287Built 2002 · Accelerated Development OrganizationN37GMCessna 340A · S/N 340A0684Built 1979 · Craft Engineering Associates IncN382NANasa Langley Research Center CARBON CUB 40% · S/N C1Nasa Langley Research CenterN385NANasa Langley Research Center CARBON CUB 40% · S/N C4Nasa Langley Research CenterN4291LCessna 172G · S/N 17254360Built 1966 · Rappa GiovanniN444JLPiper PA-28-140 · S/N 28-22224Built 1966 · Colby Christopher FN45EMSchleicher ASW-27 · S/N 27007Built 1996 · Glaab Louis JN500NUPrioria Robotics HEX FLYER · S/N NASAHF1Nasa Langley Research CtrN501NACirrus Design SR22 · S/N 0012Built 2001 · Nasa Langley Research CenterN501NUPrioria Robotics HEX FLYER · S/N NASAHF2Nasa Langley Research CenterN502NUNasa Langley Research Center EDGE 540 · S/N 21Nasa Langley Research CenterN505NUNasa Langley Research Center EDGE 540 · S/N 22Nasa Langley Research CenterN506NUCarl Goldberg AN/FQM-117B · S/N FLIC M2Nasa Langley Research CenterN507NALancair LC-40-550FG · S/N 40008Built 2000 · Nasa Langley Research CenterN507NUCarl Goldberg AN/FQM-117B · S/N FLIC A16Nasa Langley Research CenterN508NUBob Violett Models KINGCAT · S/N J-FLIC NAVY2Nasa Langley Research CenterN513NUNasa Langley Research Center PIPER PAWNEE 33% · S/N NASA-PT1Nasa Langley Research CenterN514NUCarl Goldberg AN/FQM-117B · S/N MIGLHNasa Langley Research CenterN515NU3D Robotics BIXLER · S/N BIXLER1Nasa Langley Research CenterN516NU3D Robotics Y-6 · S/N Y-6-1Nasa Langley Research CenterN520NAGulfstream Aerospace G-1159A · S/N 86-0206Nasa Langley Research CenterN521NUNasa Langley Research Center PHANTOM 2 #1 · S/N NASAP201Nasa Langley Research CenterN522NUCarl Goldberg AN/FQM-117B · S/N MIGCCNasa Langley Research CenterN523NUHanger 9 SR-22T · S/N SR-1Nasa Langley Research CenterN526PFGreiner Fred L JR ROTORWAY TALON A600 · S/N 8003Registration pendingN529NABeech B200 · S/N BB-1091Nasa Langley Research CenterN530NUNasa Langley Research Center MARS ELECTRIC FLYER · S/N MEF-2Nasa Langley Research CenterN531NUAeroworks 150CC YAK 54 · S/N YAK-24Nasa Langley Research CenterN532NUAeroworks 150CC YAK 54 · S/N YAK-25Nasa Langley Research CenterN534NUUas USA TEMPEST · S/N 080715-2Nasa Langley Research CenterN539NUDJI S1000+ · S/N ECN2663018Nasa Langley Research CenterN540NUUnreal Worx EREVKON · S/N EREVKON-1Nasa Langley Research CenterN542NUCarl Goldberg AN/FQM-117B · S/N MIG NTNasa Langley Research CenterN544NUXdrones TITAN X8 · S/N LO-10008Nasa Langley Research CenterN549NUNasa Langley Research Center Y-6-2 · S/N 002Nasa Langley Research CenterN550NUNasa Langley Research Center TAROT X-6-1 · S/N 001Nasa Langley Research CenterN551NUUavamerica EAGLE X8 · S/N 1712A02Nasa Langley Research CenterN552NUUavamerica EAGLE X8 · S/N 1712A07Nasa Langley Research CenterN553NUBlackswift Technologies S2 · S/N 1792C000000000760Nasa Langley Research CenterN556NUFreefly Systems ALTA 8 PRO · S/N ECN2688777Nasa Langley Research CenterN5571PPiper PA-24-250 · S/N 24-635Daube Timothy BN557NUFreefly Systems ALTA 8 PRO · S/N ECN2688782Nasa Langley Research CenterN558NUFreefly Systems ALTA X · S/N 1792C0000000008B2Nasa Langley Research CenterN559NUFreefly Systems ALTA 8 PRO · S/N ECN2688779Nasa Langley Research CenterN560NUFreefly Systems ALTA X · S/N ECN2688604Nasa Langley Reserarch CenterN561NUFreefly Systems ALTA 8 PRO · S/N ECN2688615Nasa Langley Research Center
Back to Hampton, VA