OpenAirDocs.org
Greenville, DE

Registered aircraft · 42

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

N112LLMBB BK 117 A-3 · S/N 7038Built 1984 · Patriot Aviation IncN157PABell 206-L4 · S/N 52241Built 2003 · Patriot Aviation IncN168DKCessna 182T · S/N 18282351Built 2012 · Otv LeasingN169PASikorsky UH-60L · S/N 83-23913Patriot Aviation IncN199TETextron T206H · S/N T20609199Built 2015 · Pxw ServicesN2097TCessna 172S · S/N 172S9585Built 2004 · Patriot Aviation IncN20ZBell Helicopter Textron 206L-1 · S/N 45334Built 1982 · Patriot Aviation IncN212PASikorsky UH-60L · S/N 84-23947Patriot Aviation IncN233AJSikorsky UH-60A · S/N 82-23685Built 1982 · Patriot Aviation IncN234EAGippsland GA-8 · S/N GA8-02-021Apache Airvan LLCN288JYCessna T206H · S/N T20608913Built 2009 · National Aircraft Leasing CorpN312BAerospatiale AS350BA · S/N 2243Patriot Aviation IncN326PSCessna 182T · S/N 18282344Built 2012 · Psl SurveysN370JHCessna 182T · S/N 18282191Built 2009 · National Aircraft Leasing CorpN385RBCessna 182T · S/N 18282199Built 2009 · National Aircraft Leasing CorpN495WWCessna 182T · S/N 18282170Built 2009 · National Aircraft Leasing CorpN496WWCessna T206H · S/N T20608912Built 2009 · National Aircraft Leasing CorporationN5007FBell Helicopter Textron 206L-1 · S/N 45186Non-citizen corporation, flight hours not reportedBuilt 1978 · Patriot Aviation IncN510KSCessna 182T · S/N 18282177Built 2009 · National Aircraft Leasing CorpN512PABell 212 · S/N 31268Built 1984 · Patriot Aviation IncN518PAHughes Helicopters HUGHES 369D · S/N 400694DBuilt 1980 · Patriot Aviation IncN519PAHughes Helicopters HUGHES 369D · S/N 370097DBuilt 1977 · Patriot Aviation IncN521PAHughes Helicopters 369FF · S/N 0015FBuilt 1985 · Patriot Aviation IncN536GRCessna 182T · S/N 18282182Built 2009 · National Aircraft Leasing CorpN608SHCessna 182T · S/N 18282198Built 2009 · National Aircraft Leasing CorpN622FHCessna 182T · S/N 18282184Built 2009 · National Aircraft Leasing CorpN622PABell 206B · S/N 2729Patriot Aviation IncN632MRCessna 182T · S/N 18282186Built 2009 · National Aircraft Leasing CorpN687RTCessna 182T · S/N 18282350Built 2012 · Fvx ResearchN7062XMesserschmitt Bolkow Blohm BO105S CBS-5 · S/N S-793Patriot Aviation IncN712MSCessna 182T · S/N 18282179Built 2009 · National Aircraft LeasingN728MPCessna T206H · S/N T20608914Built 2009 · National Aircraft Leasing CorporationN81MPCessna 182R · S/N 18268520Built 1985 · Patriot Aviation IncN8356FHughes Helicopters HUGHES 369D · S/N 1260063DPatriot Aviation IncN859JACessna 182 · S/N 18282173Built 2009 · National Aircraft LeasingN876MRDassault FALCON 900B · S/N 125Built 1994 · Budget Jet LLCN922MKCessna 182T · S/N 18282195Built 2009 · National Aircraft Leasing CorpN949RLCessna T206H · S/N T20608937Built 2009 · National Aircraft Leasing CorpN962JBCessna 182T · S/N 18282149Built 2009 · National Aircraft Leasing CorpN962PBCessna 182T · S/N 18282159Built 2009 · National Aircraft Leasing CorpN972SMCessna T206H · S/N T20608942Built 2009 · National Aircraft Leasing CorpN981GTCessna T206H · S/N T20608417Built 2003 · Patriot Aviation Inc
Back to Greenville, DE