Fremont, NE
Registered aircraft · 43
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 = 'NE' AND g.registrant_city = 'FREMONT' 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 = 'NE' AND g.registrant_city = 'FREMONT' 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.
N101KRPiper PA-12 · S/N 12-53N1374ECessna 172N · S/N 17270976N1615BLuscombe 11A · S/N 11-121N16363Piper PA-28-235 · S/N 28-7310090N181CSTextron 182T · S/N 18283280N2039NCessna 140 · S/N 12275N2135JMooney M20S · S/N 30-0022N223CLApex APEX CROSS-5X · S/N 02-02Sale reportedN23XPPattillo Patrick RV-6A · S/N 21173N300TMBeech B300 · S/N FL-50N31594Stinson 10A · S/N 7843N32260Stinson 10A · S/N 7908N3425NPiper J3C-65 · S/N 22631N35WEED & Mary Whitmore RV7 · S/N 73722N402CPCessna T206H · S/N T20608923N41065Piper J4E · S/N 4-1615N427CSocata TBM 700 · S/N 102N44154Taylorcraft BC12-D · S/N 9954N45TDPiper PA-18-150 · S/N 18-7270N4784HPiper PA-11 · S/N 11-737N4827FPiper PA-32R-300 · S/N 32R-7680479N49950Cessna 152 · S/N 15281410N49GEngineering & Research 415-C · S/N 426N501RZDJI AGRAS T100 · S/N 1581F8ZLC256400290QWN51082Cessna 150J · S/N 15069750N542JBPilatus PC-24 · S/N 164N5493DBeech H35 · S/N D-5022N56JKBeech 95-B55 (T42A) · S/N TC-1938N6055JBeech E-55 · S/N TE-1160N606DWPiper PA-31T · S/N 31T-8120038N630JMRotorsport UK ROTORSPORT UK CAVALO · S/N RSUK-V00453N6516PPiper PA-24-250 · S/N 24-1638N710DMStanley Arthur Freeman ZODIAC 601XL · S/N 5636N711FABeech B-55 · S/N TC-1982N7615XCessna 172B · S/N 17248115N7736LCessna 177B · S/N 17702603N79002Cessna 172K · S/N 17257799N80123Cessna 172M · S/N 17266385N84006Aeronca 7AC · S/N 7AC-2694N89812Cessna 152 · S/N 15282879N9175SPiper PA-24-260 · S/N 24-4664N94004Ercoupe 415-C · S/N 1327N96PAAviat A-1C-180 · S/N 3090
Back to Fremont, NE