Registered aircraft · 22

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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_state = 'IL' AND g.registrant_city = 'WATERLOO' 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_state = 'IL' AND g.registrant_city = 'WATERLOO'
  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_state = 'IL' AND g.registrant_city = 'WATERLOO'
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.

N2249SCessna T210L · S/N 21061193Built 1976 · Dlw Flight Services LLC N229MSSoutherland Murphy H JR CORBIN JUNIOR ACE E · S/N 229Schaefer John A N34860Cessna 177B · S/N 17702051Built 1973 · Pittman Charles R Trustee N3668ZPiper PA-22-150 · S/N 22-7566York Matthew J N371FZZengel Frank H RV 4 · S/N 371Built 1989 · Merkan Michael B N389BHCessna 185 · S/N 185-0098Built 1961 · Horn Bradley P N3916VCessna 170 · S/N 18226Horn Bradley P N393TMBellanca 8KCAB · S/N 82-73Built 1973 · Avion Acrobatico LLC N413PGCessna 305A · S/N 22167Built 1951 · Schaefer John A N4665KDJI AGRAS T50 · S/N 1581F6BUB246Q0016578Kruse Aerial Ag LLC N533CKDJI AGRAS T100 · S/N 1581F8ZLC25AE002Y0EYKruse Aerial Ag LLC N56215Quicksilver SPORT 2S · S/N 0214Built 2008 · Roberts Travis B N57PKPhillip L Kitchen WAG-A-BOND · S/N 1PKBuilt 2017 · Kitchen Phillip L N592JEKolb FIRESTAR KXP · S/N FS7-2-089Built 2007 · Ellebracht Gerald H N6143Talos Drones TALOS T60X · S/N 7QTDNB50011ZFTVolitix Ag LLC N7016DRoe John R ROE SPORT BIPLANE · S/N 7Crook Glenn R N701LYErickson Leif R STOL CH 701 · S/N 7-4565Built 2021 · Erickson Leif R N8499YAnderson Lee BD-4 · S/N 1Kitchen Phillip L N85406Aeronca 7AC · S/N 7AC-4146Crum John P N8869YPiper PA-39 · S/N 39-24Built 1970 · Come Fly Away LLC N92046Piper J3C-65 · S/N 7333Merkan Michael B N9853MBrenner Michael P ZENITH ZODIAC 601HDS · S/N 6-3624Built 2007 · Brenner Michael P

Back to Waterloo, IL