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.

N100VFPiper PA-32R-300 · S/N 32R-7780539Built 1977 · Meridian Aviation N100vf LLCN101TCCessna 182M · S/N 18259330Built 1968 · Tcm Flying Club IncN108CLDiamond Aircraft Ind DA20-C1 · S/N C0008Built 1998 · Tcm Flying Club IncN1099ZJohnson Dennis L CH 701 · S/N 7-6402Built 2010 · Monson Creek Ranch IncN10YWParadise Engineering QUICKIE · S/N 506Built 1981 · Warnock Tony JN110NWBell UH-1H · S/N 66-16198Built 1966 · Cbft LLCN1189GM-Squared BREESE 2 · S/N 000701Built 2005 · Durden Joseph WayneN1198BJohnstone Douglas QKSLVR MX II S R-503 · S/N 530Built 1997 · Dees Andrew CharlesN124PMCessna 550 · S/N 550-1090Built 2004 · Mc Air LLCN127CBTextron 700 · S/N 700-0121Built 2024 · Jab II LLCN129BSAerovodochody L-29 DELFIN · S/N 1722Built 1967 · Red Star Aero Holdings LLCN133CNCanadair T33-AN MK3 · S/N 133-052Built 1953 · Red Star Aero Services LLCN133NMDassault FALCON 900 EX · S/N 26Built 1998 · Regional Logistic Missions LLCN139PMAero Vodochody L39C · S/N 432913Built 1984 · Cbft LLCN1424MPiper PA-32-260 · S/N 32-7300043Built 1973 · Fly High LLCN147CBBell Textron Canada 407 · S/N 56367Built 2023 · Jab II LLCN151CBNorth American P-51D MUSTANG · S/N 124-44703Built 1944 · Jab II LLCN151DACessna 150M · S/N 15076555Built 1975 · Baumgarten Robert JN15YSTextron 680A · S/N 680A0453Built 2025 · Yellow Steel LLCN1713PWsk-Pzl Mielec MIG 17 (LIM 5) · S/N 1C1713Red Star Aero Services LLCN17299Cessna 150L · S/N 15073712Sale reportedBuilt 1972N1787ZBeech M35 · S/N D6464Washington Arron MN190BWEmbraer-Empresa Brasileira De EMB-500 · S/N 50000028Built 2009 · Jjp Aviation LLCN1961YMooney M20D · S/N 226Warnock Tony JN205YXKenneth Ellis WAIEX · S/N W0205Johnson Shawn TylerN212PZMil Moscow Helicopter MI-2 · S/N 515249077Built 1977 · Red Star Aero Services LLCN228KNMoravan N P Ortrokovice Z142 · S/N 0228Red Star Aero Services LLCN2305YCessna 177 · S/N 17700105Built 1967 · Ott Nicholas DN2342DSmith T Gunter QUICK SILVER SP II · S/N 0511Dees Andrew CN2396FCessna 210E · S/N 21058596Built 1965 · Flippin Birds Aviation LLCN242RBCessna 172S · S/N 172S11131Built 2011 · Continental Aerospace Technologies IncN2530YCessna 172D · S/N 17249830Built 1962 · Harbour William T JrN263DWCessna 182B · S/N 51970Built 1959 · Warren David TN300TDCessna 182Q · S/N 18266128Built 1978 · Continental Aerospace Technologies IncN3132VNew Piper PA-46-500TP · S/N 4697255Built 2006 · Maloney-Lyons LLCN31BLJonker Sailplanes JS3 · S/N 03-001Built 2016 · Butler Charles R IIIN32269Piper PA-28-151 · S/N 28-7515106Built 1974 · Parker Air LLCN344RBCessna 172S · S/N 172S11133Built 2011 · Continental Aerospace Technologies IncN356JTCessna 182D · S/N 18253096Built 1960 · Horizon Aviation LLCN35TCBeech 35-B33 · S/N CD-776Built 1964 · Lynn David RN367KRCirrus Design SR22 · S/N 2162Built 2006 · Yance International LLCN369KEHughes 369A · S/N 991271Built 1969 · Cbft LLCN3819ZBeech C24R · S/N MC-750Built 1981 · O'Rourke John PN391DEDornier DO28 B-1 · S/N 3074Built 1965 · Hayes Eric GN3WTCessna 501 · S/N 5010088Built 1979 · Cb LLCN40776Piper PA-28-140 · S/N 28-7425163Built 1973 · Third Coast Aircraft LLCN420EMRaytheon B300 · S/N FL-487Regional Logistic Missions LLCN4280VChampion 7AC · S/N 7AC-460Built 1951 · Eichold Bernard H IIN43320Boeing E75 · S/N 75-8413Uss Alabama Battleship Foundation IncN43456Piper PA-28-151 · S/N 28-7415499Built 1974 · Parker Air LLC
Back to Mobile, AL