OpenAirDocs.org
Department Of Aviation

Registered aircraft · 26

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
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 = 'DEPARTMENT OF AVIATION' OR list_contains(g.other_registrant_names, 'DEPARTMENT OF AVIATION')
  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.

N1407TPiper PA-34-200 · S/N 34-7250311Built 1972 · Berrien Springs, MI · Co-owner with Andrews UniversityN270UCessna 172S · S/N 172S9520Built 2003 · Albany, OH · Co-owner with Ohio UniversityN27AUPiper PA-28-181 · S/N 2843768Built 2014 · Berrien Springs, MI · Co-owner with Andrews UniversityN2VAHawker Beechcraft B300 · S/N FL-537Built 2007 · Richmond, VA · Co-owner with Commonwealth Of VirginiaN32VACessna 182P · S/N 182-63322Built 1974 · Richmond, VA · Co-owner with Commonwealth Of VirginiaN441USBoeing 737-4B7 · S/N 24812Built 1990 · Brownsville, TX · Co-owner with City Of Brownsville TexasN445DHPiper PA-28-161 · S/N 2842233Built 2005 · Albany, OH · Co-owner with Ohio UniversityN453CMCessna 172R · S/N 17280845Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN454CMCessna 172R · S/N 17280846Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN458CMCessna 172R · S/N 17280850Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN461CMCessna 172R · S/N 17280853Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN463CMCessna 172R · S/N 17280855Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN464CMCessna 172R · S/N 17280856Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN465CMCessna 172R · S/N 17280857Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN466CMCessna 172R · S/N 17280858Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN468CMCessna 172R · S/N 17280860Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN589PBeech 58 · S/N TH-1559Built 1989 · Warrensburg, MO · Co-owner with University Of Central MissouriN656CBTextron 172S · S/N 172S12800Built 2022 · Warrensburg, MO · Co-owner with University Of Central MissouriN7071MBalloon Works FIREFLY 7-15 · S/N F7-1080Built 2000 · Warrensburg, MO · Co-owner with University Of Central MissouriN720UPiper PA-28-161 · S/N 2842223Built 2005 · Albany, OH · Co-owner with Ohio UniversityN730UNew Piper PA-28-161 · S/N 2842224Built 2005 · Albany, OH · Co-owner with Ohio UniversityN740UPiper PA-28-161 · S/N 2842225Built 2005 · Albany, OH · Co-owner with Ohio UniversityN750UPiper PA-28-161 · S/N 2842226Built 2005 · Albany, OH · Co-owner with Ohio UniversityN760UNew Piper PA-28-161 · S/N 2842231Built 2005 · Albany, OH · Co-owner with Ohio UniversityN780UNew Piper PA-28-161 · S/N 2842232Built 2005 · Albany, OH · Co-owner with Ohio UniversityN800UBeech 95-B55 (T42A) · S/N TC-2276Built 1979 · Albany, OH · Co-owner with Ohio University
Back to Department Of Aviation