Registered aircraft · 21

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 = 'AL' AND g.registrant_city = 'MOODY' 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 = 'AL' AND g.registrant_city = 'MOODY'
  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 = 'AL' AND g.registrant_city = 'MOODY'
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.

N1640LFirefly Balloons GALAXY 8B · S/N GLX-1148BBuilt 2009 · Smith Roy H N1973XCessna 182H · S/N 18256073Built 1965 · Suttle Joseph Scott N207CJTextron 525C · S/N 525C0207Alliant Partners LLC N21VCCessna 525 · S/N 525-0106Built 1995 · Citation Hawk LLC N340KGCessna 340A · S/N 340A1505Built 1982 · Aero Vulcan LLC N364PKCessna 525 · S/N 525-0320Built 1999 · Sky Hawk LLC N388KTCessna 525A · S/N 525A0172Built 2003 · Cj Leasing LLC N399GCessna 525 · S/N 525-0183399g LLC N402MTCessna 525A · S/N 525A0334Built 2006 · Air Jet Plus LLC N472PADiamond Aircraft Ind DA 40 · S/N 40.472Built 2005 · Hornsby Larry G DBA N6671WPiper PA-28-140 · S/N 28-21282Sessions Max R N71ADPiper PA-30 · S/N 30-1524Sons Aviation LLC N7233UHughes 269A · S/N 16-0447Built 1964 · Suttle Joseph S N7508HSchweizer 269C · S/N S1628Built 1992 · Sons Aviation LLC N7765BDemisay Nicholas D ROTORWAY INT EXEC 90 · S/N 5158Boswell Christopher N808DLPiper PA-32-300 · S/N 32-40309Built 1967 · Sons Aviation Inc N8412XCessna 172C · S/N 17248912Built 1961 · Suttle Joe Albert N8425FPiper PA-28-151 · S/N 28-7715259Built 1976 · Sons Aviation LLC N9143PPiper PA-24-260 · S/N 24-4624Sons Aviation LLC N91RBCessna 525 · S/N 5250124Citation Sky LLC N9478GCessna 182P · S/N 18263397Built 1974 · Executive Security Solutions LLC

Back to Moody, AL