Registered aircraft · 32

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 = 'TX' AND g.registrant_city = 'ROCKPORT' 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 = 'TX' AND g.registrant_city = 'ROCKPORT'
  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 = 'TX' AND g.registrant_city = 'ROCKPORT'
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.

N1013LMooney M20R · S/N 29-0327Built 2004 · Southwest Medical Associates Inc N116BKPiper PA-32-260 · S/N 32-782Dacy Roy W N2131XCessna 337 · S/N 337-0031Brown Jerry D N2224LBeech C23 · S/N M-1875Built 1976 · Meckel Raymond T N24701Piper J4A · S/N 4-687Corry Thomas F N26995Piper J4A · S/N 4-986Built 1940 · Mckay Franklin D N321CHCessna 210 · S/N 21058061Built 1962 · Smith James Christian N3257KGlobe GC-1B · S/N 1250Krueger Hendrick N3285LCessna 172H · S/N 17256185Built 1967 · Douglass Grant N3687NPiper PA-12 · S/N 12-1937Built 1947 · Yanta Chris J N3794KPiper PA-28-140 · S/N 28-23731Built 1967 · 10 Skies LLC N381TCBeech 58TC · S/N TK-83Built 1978 · Shumate Frank T N5015CBeech B35 · S/N D-2277Krueger Hendrik Jacobus N5496ECessna 182R · S/N 18268328Built 1983 · Fair John C N560RKCessna 560 · S/N 560-0407Built 1997 · Hoover Cc LLC N5610NStarkey Alan M BEAVER RX 550 · S/N SA3335Swanson Charles W N5683WPiper PA-28-160 · S/N 28-940Built 1962 · Yanta Chris N577BBeech A35 · S/N D-1596Built 1948 · Krueger Hendrik N595AKLeslie A Bolen ZODIAC CH650B · S/N 65-8496Built 2012 · Harrison Gavin Kyle N614BSBeech 95-B55 (T42A) · S/N TC-1917Built 1975 · Picton Jerry Francis N6238WPiper PA-28-140 · S/N 28-20280Built 1964 · Burns Benjamin N631FCessna 310D · S/N 39169Built 1963 · Hayes Terry E N727ESCessna 421C · S/N 421C0268Built 1977 · Hoover421 LLC N72941Aerovodochody L-29 DELFIN · S/N 892779Built 1967 · Coastal Bend Jet Center LLC N75174Piper PA-28-140 · S/N 28-7625205Built 1976 · 10 Skies LLC N77SBPiper PA-32-300 · S/N 32-7740086Built 1977 · Yanta Chris J N8243DBeech J35 · S/N D-5345Built 1957 · Malkin John N86997Engineering & Research ERCOUPE 415-C · S/N 170Built 1945 · Corry Thomas F N876RCessna T210M · S/N 21062844Built 1978 · 76r Holdings LLC N8912DPiper PA-22-160 · S/N 22-6068First renewal noticeParris Michael D N93444Cessna 152 · S/N 15285491Sullivan Wayne N9543LGrumman American Avn. AA-5 · S/N AA5-0605Built 1974 · 10 Skies LLC

Back to Rockport, TX