Lebanon, TN
Registered aircraft · 96
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
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 = 'LEBANON' 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 = 'LEBANON' 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.
N113TLCessna T182T · S/N T18208219N11PJRyer Mike RYER S-1 · S/N 159-HN1305ZBeech 95-55 · S/N TC-119N153DWWhite Delwin H ZENITH 701 · S/N 7-6926N1JEPitts Special S-1 · S/N 510-4N2023ZBeech 95-B55 (T42A) · S/N TC-2171N2025XHoward Holmes VANS RV-10 · S/N 42645N219CSTextron T206H · S/N T20609599N21LXCirrus Design SR22T · S/N 10998N22836Cessna 150H · S/N 15068553N28499Grumman American Avn. AA-5B · S/N AA5B0642N28693Piper PA-32-300 · S/N 32-7940121N29392Culver LCA · S/N 184N29FGGrumman FM-2 · S/N 74560N30822Maule MX-7-180B · S/N 22003CN30DSSims David L RV8 · S/N 81482N31454Aeronca 65-TAC · S/N 5480TN315SRCirrus Design SR22 · S/N 2315N318CWPiper PA 46-350P · S/N 4636153N3222YCessna 182E · S/N 18254222N322SSPiper PA-28R-201T · S/N 28R-7803353N323GBBeech A36 · S/N E-647N35764Piper J5A · S/N 5-758N35YDehavilland DHC-1 T.MK. 10 · S/N C1-0281N37237Cessna 310R · S/N 310R0968N377JAJames Johnson AIRCAM · S/N AC170N38PJOhara James C P-38 · S/N P38-1N4112HMooney M20J · S/N 24-0627N41KHRainbow Skyreach BUSHCAT · S/N CH191CN43BPiper PA-30 · S/N 30-226N4458DBeech G35 · S/N D-4621N4570WRockwell International 112TC · S/N 13060N4664ZPiper PA-22-108 · S/N 22-8193N472ACAmerican Champion 7GCAA · S/N 411-98N4782RCessna 172RG · S/N 172RG0030N479JPBeech A36 · S/N E-801N5299GCessna 305A · S/N 22111N52MTTaylor Johnny And Cynthia DRAGONFLY · S/N 381N5406ZPiper PA-22-108 · S/N 22-9178N541XLLiberty Aerospace LIBERTY XL-2 · S/N 0034N56291Maule M-5-235C · S/N 7223CN56391Maule M-5-235C · S/N 7331CN56843Boeing A75N1(PT17) · S/N 75-536N57487Bellanca 7GCBC · S/N 520-73N5883QMooney M20E · S/N 806N5FMMoynahan MOYNAHAN PITTS S-1S · S/N 0001N60328Boeing A75L3 · S/N 75-047N6082VConsolidated Aeronautics LAKE LA-4-200 · S/N 794N626RNPiper PA-32-300 · S/N 32-40246N6309GCessna 150K · S/N 15071809
Back to Lebanon, TN