Registered aircraft · 19

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL

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_name = 'DELAWARE STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'DELAWARE STATE UNIVERSITY') ORDER BY g.n_number

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_name = 'DELAWARE STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'DELAWARE STATE UNIVERSITY')
  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_name = 'DELAWARE STATE UNIVERSITY' OR list_contains(g.other_registrant_names, 'DELAWARE STATE UNIVERSITY')
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.

N126DSVulcanair S P A VULCANAIR V1.0 · S/N 1020Built 2019 · Dover, DE N12FMPiper PA-28-161 · S/N 28-7816439Built 1978 · Dover, DE N171DSVulcanair S P A VULCANAIR V1.0 · S/N 1021Built 2019 · Dover, DE N279CGPiper PA-28-181 · S/N 2843399Built 2000 · Dover, DE N32376Piper PA-28-151 · S/N 28-7515141Built 1974 · Dover, DE N401DSPiper PA-34-200 · S/N 34-7250156Built 1972 · Dover, DE N402DSPiper PA-28R-200 · S/N 28R-7635004Built 1975 · Dover, DE N405DSPiper PA-28-151 · S/N 28-7715243Built 1976 · Dover, DE N406DSPiper PA-28-151 · S/N 28-7415419Built 1974 · Dover, DE N430DSPiper PA-28-161 · S/N 28-7816517Built 1978 · Dover, DE N493DSPiper PA-28-161 · S/N 28-8416011Built 1983 · Dover, DE N495DSPiper PA-28R-201 · S/N 2844012Built 1997 · Dover, DE N496DSPiper PA-28-161 · S/N 2816105Built 1993 · Dover, DE N497DSPiper PA-28-161 · S/N 28-7816567Built 1978 · Dover, DE N747DSPiper PA-44-180 · S/N 4496486Built 2019 · Dover, DE N75050Piper PA-28R-200 · S/N 28R-7635262Built 1976 · Dover, DE N979DSVulcanair S P A VULCANAIR V1.0 · S/N 1024Built 2019 · Dover, DE N982DSVulcanair S P A VULCANAIR V1.0 · S/N 1025Built 2019 · Dover, DE N994DSVulcanair S P A VULCANAIR V1.0 · S/N 1029First renewal noticeBuilt 2019 · Dover, DE

Back to Delaware State University