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 ('2071808')
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 ('2071808')
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.
N7823ZFrost Read Ferguson · Burlington, VTN7825ZBalk Martin L · Warren, NJN7828ZShelburne Airport Inc · Shelburne, VTN7829ZMclaughlin Dustin T · Abilene, KSN7830ZFlanary Kenneth Mitchell · Five Points, ALN7832ZArnold Mark D · Holloway, MNN7834ZRall Jared W · Williamsport, PAN7836ZSpartan National Holdings LLC · Missoula, MTN7837ZBouvier Louis M III · Monticello, UTFirst renewal noticeN7838ZMonnig Hans J · Westerville, OHN7840ZHorak Mark E · Valencia, CAN7849ZMorgan Gregory A · Rice, VAN7850ZBenscoter Richard S · Nordman, IDN7852ZKvservices LLC · Buckley, WAN7854ZAdams Jerry W · Dallas, TXN7860ZGideon Troy J III · Elba, ALN7861ZAmico David A · Newburyport, MAN7862ZWahlberg Randy A · Pearland, TXN7865ZSchmalzel Dennis · Allenton, MIN7866ZTucker Stanley J Trustee · Kiowa, KSN7868ZKopriva Michael J · Lanexa, VAN7870ZNp Aviation LLC · Boulder, CON7877ZRussell Jason · Melbourne, FLN7881ZSims Abner D · Blackfoot, IDN7882ZTumino Michelle R · Tyler, TXN7883ZJacobson Billy J III · Severance, CON7884ZFrenkel Amotz · Las Vegas, NVN7885ZGonzales Donald M · Columbia Station, OHN7889ZSmith Donald J · Granite Falls, WAN7893ZThompson Raymond V · Westwego, LAN7899ZJsh Farms Inc · Wapato, WAN7900ZWebber Jerry D · Cleburne, TXN7902ZBuer Bradley W · Suffolk, VAN7903ZStahlman Anna Dell · Beaverton, ORN7908ZOnyx Performance Aviation LLC · Bakersfield, CAN7910ZCooper Jeffrey S · Honeoye Falls, NYN7913ZBernhardt Michael J · North Branch, MNN7916Z$100 Hamburger LLC · Snohomish, WAN7918ZHunter Stuart R · Burgaw, NCN7920ZKts Spar Bay LLC · Coral Gables, FLN7922ZBrown Gary W · Abilene, TXN7924ZToothman Timothy L · Xenia, OHN7927ZKoehn Marshall C · Winton, CAN7934ZInternational Air Services Inc Trustee · Carson City, NVN7935ZHagerman Samuel Ion · Milan, GAN7937ZWalters James G · Luthersville, GAN7938ZStenzel Michael R · Hamburg, IAN7939ZSeibel Steven D · Wishek, NDN7941ZThiel David W · Independence, ORFirst renewal noticeN7942ZBrown David L · Hughesville, MO
Back to Cessna 150C