Registered aircraft · 17

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

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 = 'CA' AND g.registrant_city = 'MONROVIA' 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 = 'CA' AND g.registrant_city = 'MONROVIA'
  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 = 'CA' AND g.registrant_city = 'MONROVIA'
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.

N1688BChris Chen CAVALON · S/N V00123Built 2013 · Chen Chris N1836QCessna 177RG · S/N 177RG0236Built 1971 · Uebersetzig Joshua N222CSSocata TBM 700 · S/N 1014Built 2014 · Seidner Steve Trustee N3162YCessna 182E · S/N 18254162Built 1962 · Rogers Anthony L N3431RCessna 182L · S/N 18258731Built 1967 · Guibaud Albert G N35KSSchleicher ASW-24 · S/N 24032Built 1989 · Kuehn Matthias W N39XDThomas D Hall DRAGONFLY MKII · S/N 001Built 2012 · Hall Thomas D N460LACirrus Design SR20 · S/N 11159Built 2026 · Blss Aviation Group LLC N468LACirrus Design SR20 · S/N 10766Built 2025 · Blss Aviation Group LLC N524ARCirrus Design SR20 · S/N 2757Built 2021 · Blss Aviation Group LLC N5631PPiper PA-24-250 · S/N 24-701Built 1959 · Neal Brian C N6037DPiper PA-22-150 · S/N 22-4690Built 1956 · Dale Steven L N6126DPiper PA-22-150 · S/N 22-4770Built 1957 · Neal Brian C N6801TBeech B36TC · S/N EA-429Built 1984 · Hoffman Peter N6953MCessna 182P · S/N 18263898Built 1975 · N6953m Kemt Aircraft LLC N735PDCessna 182Q · S/N 18265570Built 1977 · Viola LLC N868BKAirplane Factory SLING LSA · S/N 188Built 2016 · Chen Chris

Back to Monrovia, CA