Lebanon, PA
Registered aircraft · 43
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 = 'PA' 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 = 'PA' 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.
N1069EAeronca 7AC · S/N 7AC-4620N162BKKichman Ray W ROTORWAY EXEC 162 · S/N 3505N2015QCessna 177RG · S/N 177RG0415N22AYCirrus Design SR22 · S/N 1176Registration pendingN24909Piper J3C-65 · S/N 3532N24CEBRM Aero S R O BRISTELL LSA · S/N 416/2019N262TBBalazs Thomas CX4 · S/N 371N264VKDJI T-30 · S/N 1581F446LJ5820L011X0N2712TBeech 95-C55 · S/N TE-349N2787EAeronca 7AC · S/N 7AC-6370N340FFCessna 340A · S/N 340A0495N3572SCessna 172E · S/N 17250772N3705FGreat Lakes 2T-1A-2 · S/N 0750N391EMKenneth J Hall KITFOX MODEL III · S/N 794N411JADJI AGRAS T50 · S/N 63YBM3U002004AN4269CAir Res Aviation SP Z O O T-131 JUNGMANN · S/N 2301N43HDBeech A60 · S/N P-149N4591ZPiper PA-22-108 · S/N 22-8100N481BRPiaggio Aero Industries P180 · S/N 1210N5084CBeech B35 · S/N D-2346N528DCDaniel Laray Champ WAGABOND · S/N 2165N537RSWilliam Cooper MILLER SPORT WM2 · S/N 06N538GBGreenwood Ronald H PRECEPTOR N-3 PUP · S/N 9999N55SXSalmi Neil M BA1 S-7 · S/N 1000296N58961Cessna 182P · S/N 18262429N5970WPiper PA-28-160 · S/N 28-4020N6039LAmerican AA-5 · S/N AA5-0139N6551UMooney M20C · S/N 2334N68KBPiper PA-24-180 · S/N 24-2467N6976WPiper PA-28-140 · S/N 28-21174N7243GCessna 172K · S/N 17258943N7462BChampion 7EC · S/N 7EC-520N7842ECessna 150 · S/N 17642N831WPerth Amboy BIRD A · S/N 2025-96N84739Aeronca 7AC · S/N 7AC-3456N8476MGrumman American Avn. AA-5B · S/N AA5B-1152N91825Schweizer SGU-1-19 · S/N 49N92413Piper J3C-65 · S/N 16874N967QADJI AGRAS T30 · S/N 527BK4K00100FDN9700HCessna 172M · S/N 17266323N98EDRivera Edwin A MODIFIED XYZ-001 · S/N 090446N99851Ercoupe 415-C · S/N 2474N99KBAvions Mudry ET Cie CAP 10B · S/N 229
Back to Lebanon, PA