Lititz, PA
Registered aircraft · 57
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 = 'LITITZ' 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 = 'LITITZ' 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.
N107ALTextron 172S · S/N 172S12989N108RDStinson 108-3 · S/N 108-4523N10VJLearjet 31 · S/N 018N1216Diamond Aircraft Ind DA 40 NG · S/N 40.NC225N1316RBeech 36 · S/N E-125N17603DJI INSPIRE 1 · S/N W13DBL26020459N181ABRans S6ES-COYOTE II · S/N 10001389N1934GCessna 172S · S/N 172S10129N1944ECessna 340A · S/N 340A0675N1984NCessna 140 · S/N 12220N198EDAmerican Champion 7GCAA · S/N 457-2001N2002HCameron Balloons US A-105 · S/N 5322N20597Cessna 172S · S/N 172S9947N2072JCameron Balloons US N-90 · S/N 5432N20XPLearjet 31A · S/N 197N29895Cameron Balloons US N-90 · S/N 5212N300EDGrumman American Avn. GA-7 · S/N GA7-0098N302SPCessna 140 · S/N 14408N323PRBellanca 7KCAB · S/N 381-73N3338VTextron 172S · S/N 172S13307N377RGCirrus Design SR22T · S/N 2470N383SPCessna 172S · S/N 172S8279N400VJPilatus PC-24 · S/N 124N405VJPilatus PC-24 · S/N 125N41NEPilatus PC-12/47E · S/N 2364N432BLBRM Aero Sro BRISTELL S-LSA · S/N 032/2013N451SGCirrus Design SR22T · S/N 1789N478VAVulcanair P68R · S/N 478/RN5331GCessna 172S · S/N 172S9335N543CAColumbia Aircraft Mfg LC41-550FG · S/N 41603N552TLGates Learjet 55C · S/N 139N554PMHawker Beechcraft G36 · S/N E-3821N600RVRaytheon 58 · S/N TH-1854N609BWWallace Robert B GLASTAR · S/N 5889N610GHPilatus PC-12 · S/N 103N618GColumbia Aircraft Mfg LC41-550FG · S/N 41619N627RBRolladen-Schneider LS8-18 · S/N 8302N644SDPilatus PC-12/45 · S/N 644N6884UMooney M20C · S/N 2588N711EMPiper PA-32RT-300 · S/N 32R-7885231N72728Cessna 140 · S/N 9907N74434Grumman American Avn. AA-5B · S/N AA5B-0224N748MKTextron 172S · S/N 172S12780N751RJPiper PA-28-236 · S/N 28-8011108N76470Cessna 120 · S/N 10902N7707JPiper PA-32-260 · S/N 32-1074N7775TCessna 172A · S/N 47375N823LWBell UH-1H · S/N 66-16823N8513MEagle Balloons C-7 · S/N E86796N8561GCessna 150F · S/N 15062661
Back to Lititz, PA