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

N111XXBeech 58 · S/N TH-1389Built 1983 · Bay Area Flying Service LLC N173CKCirrus Design SR22T · S/N 1727Built 2018 · Kali Equipment 2 LLC N18327Beech A36 · S/N E-1286Built 1978 · Franco Nello N231MJMooney M20K · S/N 25-0308Built 1979 · Ochabauer August N2439TCessna 182S · S/N 18280810Built 2000 · Skylane 2439t Partners LLC N2770ABeech B-60 · S/N P-492Built 1979 · Sealane LLC N324RPCessna 182T · S/N 18281422Built 2004 · Clear For Take Off LLC N375KCCessna 421C · S/N 421C1226Built 1982 · Guittard Chocolate Holdings Co N415DSGulfstream Aerospace GV-SP (G550) · S/N 5090Nexa Aviation LLC N41806Boeing A75 · S/N 75866Built 1941 · Geosits Andrew F N469HCCram Harland C STINGRAY · S/N 2DK007Built 2001 · Cram Harlan C N47053Cessna 152 · S/N 15283163Built 1979 · Semagin Arkadi N4957KNavion NAVION A · S/N NAV-4-1957Clendenin Duncan M N80888Globe GC-1B · S/N 291Jensen Luke L N8366DBeech J35 · S/N D-5485Built 1958 · Page Howard G N840CPHawker Beechcraft B200GT · S/N BY-130Built 2012 · Cotchett Pitre & Mccarthy Llp N8516MCessna 182N · S/N 18260446Built 1970 · Sealane LLC N853DTemco GC-1B · S/N 1349Built 1946 · Cruz Keoni N919JSPilatus PC-12/47E · S/N 2346Built 2024 · To US Aviation LLC N945JQDJI AGRAS T20 · S/N 4JBBJ3N0010064San Mateo County Mosquito And Vector Control Dist N968SDezan Paul 912S AIR CAM · S/N AC108Dezan Paul

Back to Burlingame, CA