Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072602')
ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2072602')
ORDER BY n_numberRun 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.
N4513BBishop Robert W · Celina, TXN4515BWestern Parachute Sales Inc · Eagle Creek, ORN4517B4517b Holding Group LLC · Moses Lake, WAN4521BWitthaus James K Jr · Anchorage, AKN4527BKrogman Aerial Spraying Inc · Lake Lillian, MNN4528BHayton James B · Sedro Woolley, WAN4530BMichael Anna B · Daytona Beach, FLN4533BHastie William B · Anchorage, AKN4534BHornung Chet R · Nikiski, AKN4537BNewsom William A · Cheraw, SCN4542BWilliamson Charles F · Ocean Isle Beach, NCN4543BGrandy Glen E · Placerville, CAN4548BSchad Anthony J · Oceanside, CAN4550BHickle William H · Inyokern, CAN4558BDe Ley Taylor · Yorba Linda, CAN4563BLarose Gary R · Anchorage, AKN4566BWagnon Bertram L · Anchorage, AKN4567BCavu LLC · Boise, IDN4571BSchumacher Eraine · Hague, NDN4572BPagel Jeffrey · Wasilla, AKN4575BKrupinshi Floyd M · Chugiak, AKN4577BHorsley David L · El Paso, TXN4584BNadon Peter M · Aztec, NMN4585BWalchshauser Scott A · Double Oak, TXN4586BGochenaur Dwight W · York Springs, PAN4593BSale Reported · Anchorage, AKSale reportedN4595BBartusek Donald L Trustee · Columbia, MDN4596BLow & Slow LLC · Columbus, OHN4597BPost William S · Custer, WAN4599BAgua Viva Ministries · Mebane, NCN4600BKlyde Jeremy M · Irvine, CAN4601BArnavair LLC · Pearland, TXN4603BMonroe Frank B · Reno, NVN4607UBlack Spruce Aviation LLC · Hermon, MEN4610AHorn Paul · Kodiak, AKN4610BHuber Gregory A · Medina, OHN4612BBenson Ian M · Portland, ORN4613BSutter Richard J · Kooskia, IDN4616BHammond Russell E · La Jolla, CAN4617BTevlin Neal · Saint Regis, MTN4618BRegistered aircraftN4619ARegistration Pending · Bakersfield, CARegistration pendingN4619BAnderson Scott A · Lindstrom, MNN4620BRucando Matthew P · Eagle River, AKN4622AMyers Matthew D · Moody, TXN4623AHickle William H · Inyokern, CAN4626BRegistered aircraftN4627BChapman Jeffrey C · Brownsburg, INN4628BForsberg Ron A · Montrose, CON4629AHamlin Jeffrey T · Fall City, WA
Back to Cessna 180