OpenAirDocs.org
Ypsilanti, MI

Registered aircraft · 138

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 = 'MI' AND g.registrant_city = 'YPSILANTI'
  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.

N100ASDassault/Sud FAN JET FALCON · S/N 274Built 1969 · Kalitta Charters LLCN108TTConsolidatedvultee Acft 108 · S/N 108-534Built 1946 · Turnbull ArchieN10KLLake August A BUCKER BU-131 · S/N 133Built 1985 · Ledbetter Jason HN163CKGates Learjet 35A · S/N 163Built 1978 · Kalitta Charters LLCN1749Schleicher AS-K13 · S/N 13046Built 1967 · Adrian Soaring Club IncN180MAMaule MX-7-180A · S/N 20048CMuston Scott AN192CKDassault Breguet FALCON 20-D · S/N 192Kalitta Charters LLCN20355Cessna 172M · S/N 17261217N20355 LLCN20MMMolino PIK-20 · S/N 20016Built 1975 · Ledbetter Jason HN217CKGates Learjet 35A · S/N 217Built 1978 · Kalitta Charters LLCN21AFSchleicher ASK-21 · S/N 21179Built 1983 · Adrian Soaring ClubN220CKGates Learjet 35A · S/N 120Built 1977 · Kalitta Charters LLCN221HPMooney M20F · S/N 670468Built 1967 · Hardie ZacharyN226CKDassault/Sud FAN JET FALCON SER D · S/N 226Built 1970 · Kalitta Charters LLCN227CKDassault/Sud FAN JET FALCON · S/N 227Built 1970 · Kalitta Charters LLCN229CKDassault/Sud FAN JET FALCON SER D · S/N 229Built 1970 · Kalitta Charters LLCN237CKGates Learjet 35A · S/N 237Built 1979 · Kalitta Charters LLCN240CKDassault/Sud FAN JET FALCON · S/N 24Built 1966 · Kalitta Charters LLCN242CKBombardier CL-600-2B16(CL601-3R · S/N 5181Built 1995 · Kalitta Air LLCN243CKRaytheon B200 · S/N BB-1596Built 1997 · Kalitta Air LLCN244CKDassault/Sud FAN JET FALCON · S/N 369Built 1977 · Kalitta Air LLCN245CKCanadair CL-600-2B16 · S/N 5139Built 1993 · Kalitta Air LLCN264CKGates Learjet 35A · S/N 264Built 1979 · Kalitta Charters LLCN273LPLearjet 45 · S/N 185Built 2001 · Kalitta Charters LLCN290CKLearjet 35A · S/N 090Built 1976 · Kalitta Charters LLCN295CKLearjet 35A · S/N 295Built 1980 · Kalitta Charters LLCN295CLBoeing 737-3Q8 · S/N 26295Built 1993 · Kalitta Charters II LLCN298CKGates Learjet 35A · S/N 298Built 1980 · Kalitta Charters LLCN325NWGates Learjet 35A · S/N 325Built 1980 · Kalitta Charters LLCN329ZABoeing 747-438 · S/N 32914Built 2003 · Kalitta Air LLCN331CKBoeing 737-300 · S/N 23747Built 1986 · Kalitta Charters II LLCN332CKBoeing 737-300 · S/N 23707Built 1987 · Kalitta Charters II LLCN335CKBoeing 737-3Y0 · S/N 26072Built 1992 · Kalitta Charters II LLCN335TWDassault/Sud FAN JET FALCON SER F · S/N 335International Turbine Indutries LLCN336CKBoeing 737-3Y0 · S/N 26070Built 1992 · Kalitta Charters II LLCN337CKBoeing 737-3Y0 · S/N 25173Built 1991 · Kalitta Charters II LLCN352CKLearjet 35A · S/N 313Built 1980 · Kalitta Charters LLCN353CKGates Learjet 35A · S/N 081Built 1976 · Kalitta Charters LLCN354CKGates Learjet 35A · S/N 353Built 1980 · Kalitta Charters LLCN3555NMooney M20F · S/N 680095Built 1967 · Larimore Jacob WilliamN355CKGates Lear Jet 35 · S/N 062Built 1976 · Kalitta Charters LLCN357CKGates Learjet 35A · S/N 323Built 1980 · Kalitta Charters LLCN35WLGates Learjet 35A · S/N 438Built 1981 · Kalitta Charters LLCN375CKBoeing 737-5L9 · S/N 28084Kalitta Charters II LLCN396CKDassault/Sud FAN JET FALCON SER F · S/N 396Built 1979 · Kalitta Charters LLCN403CKBoeing 737-4Q8 · S/N 26280Built 1992 · Kalitta Charters II LLCN405CKBoeing 737-436 · S/N 25407Built 1991 · Kalitta Charters II LLCN406CKBoeing 737-400 · S/N 28752Built 1997 · Kalitta Charters II LLCN4098FPiper PA-28-151 · S/N 28-7715004Built 1976 · N4098f LLCN431CKGates Learjet 35A · S/N 431Built 1981 · Kalitta Charters LLC
Back to Ypsilanti, MI