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.
N4632BRowbotham James · Martinez, CAN4634ABrunner Lance C · Anchorage, AKN4634BHehl Adam D · Anchorage, AKN4635AHartman Gregory G · Eagle River, AKN4635BBass Ronald · Cleveland, GAN4636ARk Air LLC · Wilmington, DEN4636BBernard David R · Sandy, UTN4637BTregeagle Richard D · Sandy, UTN4639BMoncrief Georgeanne H Trustee · Nampa, IDN4641BKey James M · Hermiston, ORN4642BRegister Edmond A · Tyler, TXN4643BAnderson Charles D · Fairbanks, AKN4644ALee Lauren M · West Greenwich, RIN4645BJacobs Lydia A · Lincoln, MEN4646ANorth Sixty Taildraggers LLC · Port Ludlow, WAN4646BBravo 300 LLC · Coweta, OKN4647AAuch Leo R · Scio, ORN4649BNicholson Stephen G · Bayfield, CON4650BByrne Robert R · Cameron Park, CAN4653AKuzina Ronald E · Wasilla, AKN4654AZerbinos Nicholas J · Anchorage, AKN4655AMasten Kirk E · Roanoke, INN4657BBeam Gregory E · Anchorage, AKN4658ALerner Michael M · Tehachapi, CAN4660AConnealy Air LLC · Whitman, NEN4660BEllison Orlo T · Broomfield, CON4661AOlson Eric T · Hudson, WIN4664BSaner Kim K · Soldotna, AKN4665ARegistered aircraftN4666BStanfield Francis T · Anchorage, AKN4669BDunbar Timothy C · Mukwonago, WIN4671BFallin Zachary R · Oracle, AZN4672ARupert Angus H · Pensacola, FLN4672BHone Christopher J · South Cle Elum, WAN4673BRacoon Aviation LLC · San Antonio, TXN4676BRobbins J Putnam · Valparaiso, INN4678BKing Paul E · Albany, ORN4679AFlying Bulldogs LLC · Joplin, MON4681ZWhite Blaine Scott · Castlewood, VAN4684AShilanski Micah V · Wasilla, AKN4685ARegistered aircraftN4686BThompson Harrison C · Brookings, SDN4687AMorris Equipment LLC · Yuma, AZN4688BAufderhar Samuel E · Lopez Island, WAN4691AAllen John L · Big Sandy, TNN4692BTruitt Cory G · Centennial, WYN4693BSutton Aircraft Salvage LLC · Palmer, AKN4696ASokol Dennis A · Milan, OHN4699AReed Aviation LLC · Pearl, MSN4706BCollegiate Peaks Aviation LLC · Salida, CO
Back to Cessna 180