Registered aircraft · 34

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 = 'MS' AND g.registrant_city = 'DIAMONDHEAD' 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 = 'MS' AND g.registrant_city = 'DIAMONDHEAD'
  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 = 'MS' AND g.registrant_city = 'DIAMONDHEAD'
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.

N103RWQuad City CHALLENGER · S/N 1194-R0515Built 1999 · Fletcher John N1422Homebuilt EAA BIPLANE · S/N WAL-1Built 1989 · Waller Jerry Wayne N17021Cessna 150L · S/N 15073587Fletcher John Guy N199KLBellanca 14-19-3 · S/N 4321Built 1966 · Webb Phillip D N2066UMaule M-4-220C · S/N 2057CBuilt 1970 · Fletcher John G N30647Piper PA-28-161 · S/N 28-7816545Registration pendingBuilt 1978 N3126BHead Balloons AX8-88 · S/N 298Jones Gary N N345BJJeppesen LANCAIR IV · S/N 015Built 2007 · Performance Aero LLC N36149Piper PA-32RT-300 · S/N 32R-7885165Built 1978 · Gilbert Paul N36335Bellanca 7GCAA · S/N 271-73Built 1973 · Simmons Darren N4015BChampion 7BCM · S/N 7BCM-401Fletcher John G N46652Cessna 172K · S/N 17257411Built 1968 · Trail Brian C N4829TPiper PA-28-180 · S/N 28-7205204Maples David R N49680Boeing A75N1(PT17) · S/N 75-2242Bergeron Jonathan C N5069FBellanca 7ECA · S/N 1341-80Built 1980 · Munns Dana K N5162PPiper PA-24 · S/N 24-178Built 1958 · Horton Melody A N5651QMooney M20C · S/N 3024Built 1965 · Kingdom Air LLC N59262Volmer Jensen VJ22 · S/N F-2Tabbert William Stanley N595HPPiper PA-32R-301 · S/N 3246017Built 1995 · Pickering Neil N6035UCessna 162 · S/N 16200156Built 2011 · Tabbert Willim N62SWBreland Robert G MIDGET MUSTANG · S/N M-I-2455Breland Robert G N6352FCessna 337A · S/N 337-0352Fletcher John G N63GEBalony Kubicek Spol Sro BB26Z · S/N 1681Jones Gary N6594FPiper PA-32R-300 · S/N 32R-7780032Built 1976 · Tabbert William N6LMGlobe GC-1B · S/N 1211Graf Peter B N7006ACessna 172 · S/N 29106Built 1956 · Fletcher John G N72MGMooney M20F · S/N 680033Built 1967 · Aerosox LLC N803JKKonkel Allen J LANCAIR IV-P · S/N LIV-506Konkel Allen J N8465PPiper PA-24-400 · S/N 26-40Built 1964 · Horton Charles S Jr N8614QBeech 35-B33 · S/N CD-809Built 1964 · Taylor Leland O N9132Arbc Inc DBA Lindstrand 69A · S/N 5251Built 2004 · Jones Gary N N925EJLott Michael C GLASTAR · S/N 5772Built 2008 · Botsay Earl J N93511Engineering & Research 415-C · S/N 834Tabbert Charles N996LLLeverence VOLMER VJ-22 · S/N 278Built 2024 · Tabbert William S

Back to Diamondhead, MS