OpenAirDocs.org
Fairhope, AL

Registered aircraft · 37

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 = 'FAIRHOPE'
  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.

N101VRMaule MT-7-235 · S/N 18023CBuilt 1995 · Dunn Thomas AN111HCCessna 150M · S/N 15077675Built 1975 · Bennett Miranda MathisN1197LCessna T206H · S/N T20608697Built 2006 · Boothe Vincent AN130MSMitsubishi MU-2B-60 · S/N 750SA3b Leasing LLCN131BVEmbraer EMB-500 · S/N 50000268Built 2011 · T.F. Warren Holdings CorpN1340JRockwell International 112A · S/N 340Built 1975 · Henry Loren MN149MECessna 182S · S/N 18280721Built 2000 · Mccrary Mike MN212VBeech V35B · S/N D-9851Built 1976 · Guilfoyle Robert JN23051Cessna 150H · S/N 15068700Gradle Roger ThomasN26CJNanchang China CJ-6A · S/N 1832046Built 1977 · Mcdonald Sean PN3130WBeech 95-B55 (T42A) · S/N TC-1635Built 1973 · Warbirds East IncN3261MCessna 182S · S/N 18280347Built 1998 · Dyas ChrisN326TKCirrus Design SR22 · S/N 0716Built 2003 · Clark Shawn BN35728Cessna 172I · S/N 17256939Built 1968 · Gone Broke LLCN3796KGlobe GC-1B · S/N 1489Built 1946 · Fletcher LarryN504TKCirrus Design SR22T · S/N 8842Built 2022 · N504tk LLCN5089CCessna T210N · S/N 21063701Built 1979 · 5089c LLCN50BTPiper PA-28-151 · S/N 28-7415164Built 1974 · Wade William TN50BVCirrus Design SR22 · S/N 8912Built 2022 · Strickland H Len JrN579MWCirrus Design SR22 · S/N 4785Built 2019 · Cqf Holdings LLCN5907CBeech C35 · S/N D-3290Built 1952 · N5907c LLCN5968WPiper PA-28-150 · S/N 28-3860Built 1967 · Dalken Dustin AN6079YAviat PITTS S-2B · S/N 5239Built 1992 · Waller Stephen BN6116NCirrus Design SR22T · S/N 8843Built 2022 · Walker StephenN6253XAero Commander 680-F · S/N 680F-1089-67Built 1961 · Moudy James DN6470MStinson 108-3 · S/N 108-4470Built 1947 · Christensen Steven HN653DSDiamond Aircraft Ind DA 40 · S/N 40.853Built 2007 · Lucy LLCN810KTCessna 150F · S/N 15063745Built 1966 · Davis John MN82007Aeronca 7AC · S/N 7AC-632Built 1946 · Caldwell George AN84456Cessna 172K · S/N 17258477Built 1969 · Warbirds East IncN8724Bellanca 8KCAB · S/N 77-73Built 1973 · Fairhope Decathalon LLCN896MACessna 550 · S/N 550-1065Built 2003 · Q-Sky LLCN921UMMikoyan Gurevich MIG 21 UM · S/N 516979001L-29 Holdings LLCN9253GCessna 182N · S/N 18260793Built 1971 · Steiner Ivy CN929JWCirrus Design SR20 · S/N 2296Built 2015 · Alift LLCN9589LGrumman American Avn. AA-5 · S/N AA5-0589Built 1974 · Vincent Jared HN9986UGrumman American Avn. AA-5A · S/N AA5A0386Freeman Andrew G
Back to Fairhope, AL