Albany, GA
Registered aircraft · 52
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 = 'GA' AND g.registrant_city = 'ALBANY' 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 = 'GA' AND g.registrant_city = 'ALBANY' 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.
N107TQCirrus Design SR22 · S/N 3996N16WBTextron 525 · S/N 525-0905N1937ACub Crafters CC11-100 · S/N CC11-00023N194MGCessna 525 · S/N 525-0357N2150LBeech 58 · S/N TH-781N260ARBeech 58P · S/N TJ436N2721EAeronca 7AC · S/N 7AC-6301N279CPCirrus Design SR22 · S/N 3221N2873YCessna 182E · S/N 18253873N364RCRaytheon G36 · S/N E-3723N372DCCirrus Design SR20 · S/N 1210N3839RBeech A36TC · S/N EA-199N414GMExtra Flugzeugproduktions UND EA 300/SX · S/N SX008N43108Piper PA-32-300 · S/N 32-7440116N476JWRobinson Helicopter R44 II · S/N 14514N4822VBellanca 17-30 · S/N 30092N486CCCessna 525 · S/N 525-0213N49JBTilley Robert COZY III · S/N 049N5101CThrush S2R-T34 · S/N T34-502N5102AThrush S2R-T34 · S/N T34-503N510XCThrush S2R-510 · S/N 510-152DCN5128TThrush S2R-T660 · S/N T660-156N5129LThrush S2R-T660 · S/N T660-157N51686Thrush S2R-T660 · S/N T660-170DCN5170FThrush S2R-T660 · S/N T660-171DCN543AHHartman Alfonse A RV6A · S/N 20543N557AGDJI AGRAS T40 · S/N 64TBL4E00200EBN61759Cessna 172M · S/N 17264780N6216UThrush S2R-H80 · S/N H80-192N644HKKuebler Herman J III LONG EZ · S/N 644N64664Cessna 172P · S/N 17275600N6753RCessna T210F · S/N T210-0153N6872VMooney M20F · S/N 22-1265N7001CThrush S2R-T660 · S/N T660-190N70035Thrush S2R-510 · S/N 510-156N70058Thrush S2R-T660 · S/N T660-198DCN70059Thrush S2R-510 · S/N 510-539N7005DThrush S2R-510 · S/N 510-161N7005RThrush S2R-510 · S/N 510-163DCN7005YThrush S2R-510 · S/N 510-158N7329WPiper PA-28-180 · S/N 28-1200N780MCThrush S2R-510 · S/N 510-536DCN7822PPiper PA-24-250 · S/N 24-3041N793MCThrush S2R-510 · S/N 510-162DCN841DSDiamond Aircraft Ind DA 40 · S/N 40.881N866MWMark Mccorkle SLING TSI · S/N 252SKN889FTRaytheon 58 · S/N TH-1828N88GGGlasgo STARDUSTER II · S/N 3N919GMExtra Flugzeugbau EA 300/S · S/N 1033N931GGRaytheon C90A · S/N LJ-1572
Back to Albany, GA