Mobile, AL
Registered aircraft · 143
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.
N100VFPiper PA-32R-300 · S/N 32R-7780539N101TCCessna 182M · S/N 18259330N108CLDiamond Aircraft Ind DA20-C1 · S/N C0008N1099ZJohnson Dennis L CH 701 · S/N 7-6402N10YWParadise Engineering QUICKIE · S/N 506N110NWBell UH-1H · S/N 66-16198N1189GM-Squared BREESE 2 · S/N 000701N1198BJohnstone Douglas QKSLVR MX II S R-503 · S/N 530N124PMCessna 550 · S/N 550-1090N127CBTextron 700 · S/N 700-0121N129BSAerovodochody L-29 DELFIN · S/N 1722N133CNCanadair T33-AN MK3 · S/N 133-052N133NMDassault FALCON 900 EX · S/N 26N139PMAero Vodochody L39C · S/N 432913N1424MPiper PA-32-260 · S/N 32-7300043N147CBBell Textron Canada 407 · S/N 56367N151CBNorth American P-51D MUSTANG · S/N 124-44703N151DACessna 150M · S/N 15076555N15YSTextron 680A · S/N 680A0453N1713PWsk-Pzl Mielec MIG 17 (LIM 5) · S/N 1C1713N17299Cessna 150L · S/N 15073712Sale reportedN1787ZBeech M35 · S/N D6464N190BWEmbraer-Empresa Brasileira De EMB-500 · S/N 50000028N1961YMooney M20D · S/N 226N205YXKenneth Ellis WAIEX · S/N W0205N212PZMil Moscow Helicopter MI-2 · S/N 515249077N228KNMoravan N P Ortrokovice Z142 · S/N 0228N2305YCessna 177 · S/N 17700105N2342DSmith T Gunter QUICK SILVER SP II · S/N 0511N2396FCessna 210E · S/N 21058596N242RBCessna 172S · S/N 172S11131N2530YCessna 172D · S/N 17249830N263DWCessna 182B · S/N 51970N300TDCessna 182Q · S/N 18266128N3132VNew Piper PA-46-500TP · S/N 4697255N31BLJonker Sailplanes JS3 · S/N 03-001N32269Piper PA-28-151 · S/N 28-7515106N344RBCessna 172S · S/N 172S11133N356JTCessna 182D · S/N 18253096N35TCBeech 35-B33 · S/N CD-776N367KRCirrus Design SR22 · S/N 2162N369KEHughes 369A · S/N 991271N3819ZBeech C24R · S/N MC-750N391DEDornier DO28 B-1 · S/N 3074N3WTCessna 501 · S/N 5010088N40776Piper PA-28-140 · S/N 28-7425163N420EMRaytheon B300 · S/N FL-487N4280VChampion 7AC · S/N 7AC-460N43320Boeing E75 · S/N 75-8413N43456Piper PA-28-151 · S/N 28-7415499
Back to Mobile, AL