OpenAirDocs.org
Waterford, MI

Registered aircraft · 167

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

N1059ZAdams Balloon A55 · S/N 073Built 1981 · Gauthier Daniel RN108RMotory Group SLING TSI · S/N 249SKBuilt 2024 · Eagle 100 LLCN1147Piper PA-30 · S/N 30-423Built 1964 · N7371y LLCN120RADassault/Sud FAN JET FALCON SER D · S/N 211Royal Air Freight IncN123RADassault/Sud FAN JET FALCON · S/N 30Built 1966 · Royal Air Freight IncN12RPGates Learjet 35A · S/N 278Built 1980 · Royal Air Freight IncN13160Cessna 172M · S/N 17262538Built 1973 · Dey James MN131FLConvair 340 · S/N 155Built 1955 · Ifl Group IncN141DCRobinson Helicopter R44 · S/N 1495Built 2005 · Magnum Leasing LLCN141FLConvair 340 · S/N 111Built 1953 · Ifl Group IncN151FLConvair 340 · S/N 51Built 1953 · Ifl Group IncN1538BLuscombe 8A · S/N 6165Built 1981 · Shiffer Lyle JN159RAGates Lear Jet 35 · S/N 024Built 1975 · Bar Aircraft Leasing LLCN16080Cessna 150L · S/N 15073462150 Flyers LLCN166RADassault/Sud FAN JET FALCON SER F · S/N 449Built 1981 · Royal Air Freight IncN171FLConvair 440 · S/N 318Built 1956 · Ifl Group IncN1768ECessna 310R · S/N 310R1566Built 1978 · Royal Air Freight IncN1788NCessna 140 · S/N 12032Built 1946 · Lahti MattN178PJPhantom Aeronautics PHANTOM · S/N PH00178Built 1983 · Desrosiers Randy GN181FLConvair 440 · S/N 387Built 1956 · Ifl Group IncN184WWDassault-Breguet MYSTERE FALCON 20-F5 · S/N 352Built 1976 · Royal Air Freight IncN18RALearjet 35A · S/N 35A-513Built 1999 · Royal Air Freight IncN191FLConvair CV-440-79 · S/N 326Built 1956 · Ifl Group IncN19TDDassault-Breguet FALCON 20 · S/N 416Built 1979 · Royal Air Freight IncN204CFCessna 550 · S/N 550-0238Built 1980 · Corporate Flight IncN207TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2012USABuilt 1991 · Gauthier Martin TN20WKDassault/Sud FAN JET FALCON · S/N 310Built 1974 · Royal Air Freight IncN220RABeech B200 · S/N BB-1130Built 1983 · Royal Air Freight IncN224JFCirrus Design SR22 · S/N 2031Built 2006 · 224jf LLCN23055Luscombe 8C · S/N 979Plentis Walter IIN239CDDassault-Breguet MYSTERE FALCON 20-F5 · S/N 339Built 1975 · Royal Air Freight IncN239JVBeech B200 · S/N BB-1014Built 1982 · Rim Group LLCN2557SCessna R182 · S/N R18201349Agri-Flight LLCN285DHGates Learjet 55 · S/N 026Built 1982 · Royal Air Freight IncN299JCDassault/Sud FAN JET FALCON SER F · S/N 299Built 1974 · Royal Air Freight IncN3011GArbc Inc DBA Lindstrand 69X · S/N 5721Built 2020 · Gauthier Travis GN306BHDassault FALCON 2000 · S/N 220Built 2005 · Sdy Leasing LLCN31RAGates Learjet 35A · S/N 288Built 1979 · Royal Air Freight IncN329CMAmerican Champion 7EC · S/N 1038-2015Built 2016 · Gwb Air LLCN32AALearjet 45 · S/N 399Built 2009 · Smolyanov Aviation Holdings LLCN3368NPiper J3C-65 · S/N 22568Built 1946 · Versatile Aviation LLCN34AEmbraer EMB-110P1 · S/N 110.350Built 1981 · Royal Air Freight IncN35149Piper J3C-65 · S/N 6174Versatile Aviation LLCN351ASGates Learjet 35A · S/N 146Built 1977 · Royal Air Freight IncN351FLConvair 340 · S/N 279Built 1955 · Gulf & Caribbean Cargo IncN360WBBaumann Wayne Robert RV-6 · S/N 23085Built 1999 · Baumann Wayne RN361FLConvair 440 · S/N 343Built 1956 · Gulf & Caribbean Cargo IncN365AGDassault FALCON 2000EX · S/N 50Built 2004 · Aga Holdings LLCN371FLConvair 340 · S/N 309Built 1956 · Ifl Group IncN381FLConvair 340 · S/N 276Built 1953 · Ifl Group Inc
Back to Waterford, MI