Enterprise, AL
Registered aircraft · 78
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 = 'ENTERPRISE' 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 = 'ENTERPRISE' 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.
N1090Mills PITTS SPECIAL S-1C · S/N JM-4-24-38N12876Cessna 172M · S/N 17262335N1384WMooney M20C · S/N 2665N149EEFocke-Wulf FWP 149D · S/N 157N163MSMankovich Stanley J ROSE PARAKEET · S/N 63N16AKPiper PA-28RT-201 · S/N 28R-7918057N184AASikorsky UH-60A · S/N 81-23556N1967BLuscombe 8A · S/N 6394N2105QCessna 177RG · S/N 177RG0505N211WSmith AEROSTAR 600A · S/N 60-0460-153N213ZBeech 95-B55 (T42A) · S/N TC-672N223MBeech M35 · S/N D-6524N22419Piper PA-32RT-300 · S/N 32R-7885270N241JPPiper PA-30 · S/N 30-241N267CLTextron B200GT · S/N BY-267N2756VCessna 177RG · S/N 177RG0682N2771EAeronca 7AC · S/N 7AC-6355N2957Billig-Burrows STARDUSTER TOO · S/N 402N300DRMay Gerald F FOKKER DR1 · S/N 300N3034JCessna 170A · S/N 18774N30LNLancair LC-40-550FG · S/N 40046N32613Piper PA-28R-200 · S/N 28R-7535072N327PPMorse Gary VANS RV7A · S/N 70380N339AFRamsey E C FIRESTAR II · S/N FS 06-4-000-82N3414WPiper PA-32-260 · S/N 32-276N3833MPiper PA-12 · S/N 12-2750N38636Piper PA-28R-201T · S/N 28R-7703253N3962RPiper PA-28-180 · S/N 28-7105067N40850Piper PA-28-140 · S/N 28-7425178N4145SStrickland Benjamin F CHALLENGER II · S/N CH203951314N426AMMarrero Edgardo ACEY DEUCY P-70 · S/N 0521N4296RPiper PA-32-300 · S/N 32-40674N4SRMooney M20K · S/N 25-0132N50551Cessna 150J · S/N 15069392N5386FPiper PA-28-151 · S/N 28-7715116N545FLPiper PA-28-140 · S/N 28-7125378N54TZFrank B Butts RV9A · S/N 90675N5520PPiper PA-24-180 · S/N 24-583N556GACzech Sport PIPER SPORT · S/N P1001030N573CDCirrus Design SR22 · S/N 1038N6035TCessna 150D · S/N 15060735N606DSSikorsky EH-60A · S/N 85-24466N6100PPiper PA-24-180 · S/N 24-1198N61536Cessna 172M · S/N 17264622N6306JPiper PA-28-180 · S/N 28-4717N6761ACessna 172 · S/N 28861N7059PPiper PA-24 · S/N 24-2209N7139QCessna 172L · S/N 17260439N714NLCessna 150M · S/N 15079303N71731Cessna 182M · S/N 18259733
Back to Enterprise, AL