Registered aircraft · 29

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 = 'TN' AND g.registrant_city = 'LAKELAND' 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 = 'TN' AND g.registrant_city = 'LAKELAND'
  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 = 'TN' AND g.registrant_city = 'LAKELAND'
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.

N104BSSutherland Brian S RV-10 · S/N 40308Built 2007 · Peters Terry E N126JHBeech 200 · S/N BB-595Built 1980 · M&P Aviation LLC N195MKCessna 195B · S/N 7907Built 1952 · Scholten Calvin B N1ZBCessna LC-126C · S/N 7855Butcher Darren E N21NAMooney M20F · S/N 680203Built 1968 · Beck Donald R N22772Piper J4A · S/N 4-456Built 1939 · Wilcox J K N2494APiper PA-18-135 · S/N 18-1961Built 1952 · Otto Justin N250WAPiper PA-32-300 · S/N 32-7840102Built 1978 · Welch Eric N2739TBeech V35 · S/N D-8457Built 1967 · Pickering Kevin P N310RGCessna T310R · S/N 310R0856Built 1977 · Rome Aviation LLC N36FERaytheon A36 · S/N E-3385Built 2001 · Seenikkib Real Estate LLC N36JKKirby James C SKYBOLT · S/N JCK-3Built 1991 · Wilcox J K N408WGCirrus Design SR22 · S/N 3565Built 2009 · Blue Sky 408 LLC N4263SFairchild 24W-46 · S/N W46299Built 1946 · Robbins III James E N4851BCessna 152 · S/N 15283673Built 1979 · Code Supplies Inc N5569RCessna 172F · S/N 17253163Built 1965 · Aluminum Falcon LLC N605TTBearden Jeff RV-8 · S/N 82563Built 2018 · Bearden Jeff N6778MCessna 210M · S/N 21061990Built 1977 · Nikodem Daniel E N6784HPiper J3C-65 · S/N 19997Built 1946 · Butcher Darren E N716PGAlexander Norman E LEGACY FG · S/N LS-226Built 2009 · Alexander Pamela G N76HCCessna 182P · S/N 18262234Hp Premier Solutions LLC N776BRCirrus Design SR22T · S/N 1904Built 2019 · Willow Tree Tennessee LLC N77AJPiper PA-32R-300 · S/N 32R-7680371Built 1976 · Green Nicholas S N822KCBeech B-60 · S/N P-499Built 1979 · Lucky Fighter Aviation Services LLC N826VRNoble Robert Allen VELOCITY RG · S/N DMO-216Registration pendingBuilt 1999 N85LSScholten Calvin B CS EXP SUPERCUB · S/N CS-1First renewal noticeBuilt 2011 · Scholten Calvin B N942TBeech B95 · S/N TD-363Built 1960 · Billen Jarod H N96810Cessna 182Q · S/N 18266859Built 1979 · Gordin Michael E N9809KPiper PA-28R-201 · S/N 28R-7837039Built 1977 · S&S Investment Solutions LLC

Back to Lakeland, TN