Mobile, AL
Registered aircraft · 144
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 = 'MOBILE' 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 = 'MOBILE' 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.
N704LRCessna 150M · S/N 15078700N7116VMooney M20C · S/N 20-0029N712CVCirrus Design SF50 · S/N 0712N7135DFound Aircraft Canada FBA-2C3 · S/N 305N7218TCessna 172A · S/N 46818First renewal noticeN724CMCirrus Design SR22 · S/N 1557N7376XCessna 150B · S/N 15059476N737CKCessna 172N · S/N 17269312N754BWPiper PA-28-181 · S/N 2843233N766VNCessna 182A · S/N 34561N78071Globe GC-1B · S/N 2071N786SICP SAVANNA S · S/N 22-11-54-0916N78RBoeing A75N1(PT17) · S/N 75-1013N798BBCirrus Design SR22 · S/N 1435N79NWBell UH-1H · S/N 64-13710N8109LCessna 172H · S/N 17256309N8115SCessna 150F · S/N 15061715N818JECirrus Design SR22T · S/N 10944N81FSYakovlev YAK 52 · S/N 9311704N828GPPiper PA 46-350P · S/N 4636514N8313PPiper PA-24-250 · S/N 24-3563N838UMM-Squared BREESE 2 · S/N 01-2018-0806N84GBBoudreaux Gary L VARIEZE · S/N 1N8517AConstrucciones Aeronauticas C-212-CC · S/N 178N86CSEvans Thomas N LONG-EZ · S/N 701N876LSElsner Lynn VELOCITY STD RG · S/N SRG 059N893MCCessna 510 · S/N 510-0120N896CGCessna 550 · S/N 550-1055N896KKBell Textron Canada 407 · S/N 54928N8AECirrus Design SR22 · S/N 2999N90CWHonda HA-420 · S/N 42000125N911GSBeech A36 · S/N E-1785N917FMikoyan MIG-17 · S/N 1C1613N91HGCessna 501 · S/N 501-0199N923ACYarmey Alan J COZY · S/N 42N923CMCirrus Design SR22 · S/N 9312N92846Cessna 182N · S/N 18260392N9322TCirrus Design SR22T · S/N 2031N9337GCessna 182P · S/N 18260877N936CMCirrus Design SR22 · S/N 2447N9786XCessna 210C · S/N 21058086N983CBCbft AL18 · S/N AL-392N987FMCessna 182Q · S/N 18266706N99764Engineering & Research 415-C · S/N 2387
Back to Mobile, AL