Tuscaloosa, AL
Registered aircraft · 76
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 = 'AL' AND g.registrant_city = 'TUSCALOOSA' 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 = 'AL' AND g.registrant_city = 'TUSCALOOSA' 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.
N128WRBoeing A75N1 · S/N 75-884N134PFPilatus PC-12/47E · S/N 1491N1355TPiper PA-32-300 · S/N 32-7240115N135PFPilatus PC-12/47E · S/N 1752N136PFPilatus PC-12/47G · S/N 3016N1522YCessna 172C · S/N 17249222N1712QCessna 150L · S/N 15073012N177ECessna 560XL · S/N 560-5699N1UACessna 680 · S/N 680-0312First renewal noticeN2062EAeronca 7AC · S/N 7AC-5632N210CUCessna 210N · S/N 21064452N212CJCessna LC41-550FG · S/N 411065N214CCCessna 421C · S/N 421C0670N2310SCessna T337B · S/N 337-0610N231GGMooney M20K · S/N 25-0171N245XLTextron 560XL · S/N 560-6245N24UASky Arrow 650 TCNS · S/N CNS029N272RVTextron 525C · S/N 525C0285N272XTDJI AGRAS T40 · S/N 4LGZL57007023TN27CJCessna 525 · S/N 525-0311N291FJDassault MYSTERE FALCON 50EX · S/N 291N29AJCessna T206H · S/N T20609119N3024XCessna 150F · S/N 15064424N3053APiper PA-28-236 · S/N 28-7911007N306SCadby Ronald B RONS RANS 9 · S/N 0488051N3112UCessna 182F · S/N 18254512N3172GDJI AGRAS T50 · S/N 7TNBMCS00403XHN331AMAeroprakt Mfg SP Z O O A32 · S/N 085N3869LLenhart George B JR ROTORWAY 162F · S/N 6357N4062ACessna 310R · S/N 310R1362N41243Piper PA-28-151 · S/N 28-7415146N41589Piper PA-28-151 · S/N 28-7415140N42219Cessna 182L · S/N 18258908N42275Cessna 182L · S/N 18258937N448TDCessna 182 · S/N 18265319N44903Piper PA-28R-201T · S/N 28R-7703341N4825TCostruzioni Aeronautiche Tecna P2010 · S/N 073/USN4966GCessna 172N · S/N 17273513N4JABeech 58 · S/N TH-1714N5073EWatson Garland M 2000 · S/N GM2000N528KTThomas Kenneth LYN KR2S · S/N 003N5301TPiper PA-28R-200 · S/N 28R-7235222N53220Cirrus Design SR22 · S/N 0865N536XFDJI AGRAS T100 · S/N 1581F8ZLC25AB002K7P9N536YFDJI AGRAS T100 · S/N 1581F8ZLC25AB002J17ZN536ZFDJI AGRAS T50 · S/N 1581F6BUB24B400108XSN5498NAeronca 7BCM · S/N 7BCM-251N54YPDassault MYSTERE-FALCON 50 · S/N 333N54YRDassault FALCON 2000EX · S/N 300N5627XKlass CRUISE · S/N A15JAG
Back to Tuscaloosa, AL