Latrobe, PA
Registered aircraft · 42
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 = 'LATROBE' 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 = 'LATROBE' 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.
N13445Cessna 172M · S/N 17262756N15235Piper PA-28-140 · S/N 28-7325026N1APCessna 750 · S/N 750-0176N22260Cessna 150H · S/N 15068174N228YBombardier BD-100-1A10 · S/N 20447N24385Cessna 152 · S/N 15280248N267BWGulfstream Aerospace GVI (G650ER) · S/N 6156N26CMBeech 95 · S/N TD-119N331GWTextron 182T · S/N 18283147N35377Cessna 172I · S/N 17256740N369MNCessna 525B · S/N 525B0314N407BEBell 407 · S/N 53576N40WVCessna 525B · S/N 525B0412N46731Cessna 172K · S/N 17257459N47EKTextron 560XL · S/N 560-6147N48PCTayler Baron VOYAGER · S/N 00001N50EKCessna 560XL · S/N 560-6112N512TRCirrus Design SR22 · S/N 0993N53039Cessna 172S · S/N 172S9259N533SEMccaa Robert T AVID/KITFOX FLYER · S/N M002N6174RCessna 172RG · S/N 172RG0103N64232Cessna 172M · S/N 17265108N67842Cessna 152 · S/N 15282051N67865Cessna 152 · S/N 15282069N6NYCessna 525C · S/N 525C0148N715DJCirrus Design SF50 · S/N 0512N7187QCessna 172L · S/N 17260487N737HECessna 172N · S/N 17269423N765CMRobinson Helicopter R44 · S/N 2017N775AHCirrus Design SR22T · S/N 0359N78623Cessna 172K · S/N 17257690N788MRMarkus Heinimann SLING HW · S/N 090GKN799TCessna 177RG · S/N 177RG1276N80816Cessna 172M · S/N 17266760N827CChabal Joseph RV-8A · S/N 81106N8406LCessna 172I · S/N 17256606N84659Cessna 172K · S/N 17258566N8803KStinson 108-1 · S/N 108-1803N8944YPiper PA-39 · S/N 39-105N962MMGulfstream Aerospace G-V · S/N 605N9861GCessna 172L · S/N 17259761N998MAPiper PA-32R-301 · S/N 3246105
Back to Latrobe, PA