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 ('2072604')
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 ('2072604')
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.
N889JBeasley William D Sr Trustee · Big Lake, AKN889SLCunningham Richard Scott · Bedford, TXN911BWOlsen Garry O · Forest Lake, MNN91954Suchland Simon K · Fairbanks, AKN9504BVan Winkle Randy M · Van Buren, MON9507BHanderson Ronald Jr Sr · Sitka, AKN9511BRadford Kenneth J Jr · Chugiak, AKN9524BMeierotto Jeff T · Two Rivers, AKN9528BNorris John R · Anchorage, AKN9533BWilson Thomas Henry III · Anchorage, AKN9534BNissel James G · Saint Marys, PAN9541BBodick John K · Anchorage, AKN9558BGrap Jeffrey G · Statham, GAN9560BAltair Aircraft LLC · Gainesville, FLN9570BStriplin Bradley H · Pittsboro, NCN9571BFarrell Mark A · Omaha, NEN9580BEds Flying Service Inc · Denton, MTN9586BAmidon Gary · Shady Cove, ORN9588BSmith Timothy E · Anchorage, AKN9596BWagner Bryson R · Granville, PAN95AMWilkes Flying Service Inc · Simmesport, LAN9606BAnderson David R · Sycamore, ILN9613BLiebsch Mark W · Reno, NVN9621BLee Gerald R · Glennallen, AKN9622BSmith Glenn R · Palmer, AKN9628BBryan Kirk J · Big Timber, MTN9629BVisser Ag Inc · Rigby, IDN9632BDbstd LLC · Nickerson, NEN9641BFlying Brown Dog LLC · Boulder, CON9661BKennemer Vaughn · Carter, OKN9675BBlessum Jay · Minot, NDN9676BAnselment Barney A · Polson, MTN9679BRuehle Alex A · Denver, CON9685BJones Jason B · Anchorage, AKN9689BCoffin Robert H · Wasilla, AKN9691BRegistered aircraftN9705BRovey James A · Troy, IDN9708BBaxter Christopher V · Anchorage, AKN9712BLafleur Kerry P · Fort Worth, TXN9716BSelkirk Associates Inc · Wilmington, DEN9728BLowery Janell D · Anchorage, AKN9729BAnderson Benjamin T · Havre De Grace, MDN9736BWrigley David C · Anchorage, AKN9749BLee Norman S · Green Valley, AZN9751BDoyle Kevin M · Kenai, AKN9755BRs Specialties LLC · Anchorage, AKN9759BHernandez Raymond · Burleson, TXN9763BS-3 Aero Ent LLC · Denton, TXN9764BPowder Hound LLC · Girdwood, AKN9776BStrader Wayne G · Ardmore, OK
Back to Cessna 180A