Rehoboth Beach, DE
Registered aircraft · 59
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 = 'DE' AND g.registrant_city = 'REHOBOTH BEACH' 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 = 'DE' AND g.registrant_city = 'REHOBOTH BEACH' 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.
N1036XPiper PA-32-300 · S/N 32-7540131N10446Cessna 172M · S/N 172-62515N106RDRobinson Helicopter R22 MARINER · S/N 925MN12396Robinson Helicopter R22 BETA · S/N 0646N12424Robinson Helicopter R22 · S/N 0130N1244CCirrus Design SR22T · S/N 1953N12475Robinson Helicopter R22 ALPHA · S/N 0453N12536Robinson Helicopter R22 BETA · S/N 0786N12615Robinson Helicopter R22 BETA · S/N 1205N12699Robinson Helicopter R22 · S/N 0063N12715Robinson Helicopter R22 · S/N 0103N12857Robinson Helicopter R22 ALPHA · S/N 0449N12896Robinson Helicopter R22 · S/N 0237N194HCRobinson Helicopter R22 MARINER · S/N 1955MN231TMRobinson Helicopter R22 · S/N 2317MN23469Cessna 150H · S/N 15068970N2385YRobinson Helicopter R22 MARINER · S/N 0538N2622MRobinson Helicopter R22 MARINER · S/N 0735MN2627MRobinson Helicopter R22 MARINER · S/N 755MN2663JRobinson Helicopter R22 BETA · S/N 0877N27619Taylorcraft BC-65 · S/N 2261N292PDRobinson Helicopter R22 MARINER · S/N 2498MN301HERobinson Helicopter R22 MARINER · S/N 2382MN3020APilatus PC-12/47E · S/N 2327N302SBGulfstream Aerospace GV-SP (G550) · S/N 5026N320LCMuecke Larry B LANCAIR 320 · S/N 281-320-44N341VHRobinson Helicopter R22 MARINER · S/N 2303MN376BHRobinson Helicopter R22 BETA · S/N 0851N377BMRobinson Helicopter R22 MARINER · S/N 1691MN378UHRobinson Helicopter R22 BETA · S/N 0622N42986Piper PA-32-301 · S/N 32-8306024N42WCRobinson Helicopter R22 MARINER · S/N 1531MN4346APiper PA-22-150 · S/N 22-3702N454RTCostruzioni Aeronautiche Tecna P2010 TDI · S/N 154/USN456PHRobinson Helicopter R22 MARINER · S/N 659MN45SNKosmin Donald D RV9-A · S/N 90594N6614NTaylorcraft BCS12D-4-85 · S/N 4-13014N69256Fairchild M-62A-3 · S/N FV-257N696DKKlinefelter Dale L RV6A · S/N 20636N697KAFoxair KITFOX LIGHT SPORT · S/N KA20196457N7086ZPiper PA-31-310 · S/N 31-7812083N769RCCammack Robert E CHALLENGER II · S/N CH2-0107-Y-2782N800BPRobinson Helicopter R22 BETA · S/N 1263N80407Robinson Helicopter R22 BETA · S/N 1038N80645Robinson Helicopter R22 MARINER · S/N 2304MN8066URobinson Helicopter R22 BETA · S/N 1273N818BTCompagnie Daher TBM 700 · S/N 1388N8316DRobinson Helicopter R22 MARINER · S/N 2481MN8316NRobinson Helicopter R22 BETA · S/N 2480N83TREvolution REVOLT · S/N 001043
Back to Rehoboth Beach, DE