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 ('2073202')
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 ('2073202')
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.
N1205BEngel Shane J · Willow, AKN136JRaichl John P · Astoria, ORN145PPainter Bryan J · Renton, WAN1801ZGould Robert R Jr · Sterling, VAN1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedN1809ZCleared For Departure LLC · Kennewick, WAN1810ZRanzway Corp · Seattle, WAN1821SBailey Ralph E · Sikeston, MON1822ZAhrens Kevin Michael · Cashmere, WAN1828ZHorrocks Charles M · Blackfoot, IDN1833ZEastwood Gregory S · Red Oak, TXN1838ZAgee Mark L · Greenacres, WAN1842ZVermont Skydiving Adventures Inc · Bristol, VTN1843ZVacek George T Jr · Anchorage, AKN1848ZBritt Robert J · Augres, MIN1854ZBargabos William M · Wasilla, AKN1858ZPairofminutes LLC · Marshville, NCN1865ZBpf Equipment LLC · Burnet, TXN1869ZPinnell Bradley T · Lake Havasu City, AZN1870ZZerkel Kirk Zachary · Wasilla, AKN1874ZSiggard Kurtis K · Sacramento, CAN1876ZHzl Hanger LLC · Drums, PAN1887ZDavidson David R · Sutton, AKN1890ZAlaniz Jose M · Yreka, CAN1898ZSmart Robbie A · Wasilla, AKN1899ZLarlee Coleman R · Millbrook, ALN205AAHzl Hanger LLC · Drums, PAN205CLFreedenberg Philip J · Canton, CTN205CTBas Part Sales LLC · Greeley, CON205HNTischer Jesse · Des Moines, IAN205LSky King Airplanes LLC · Lewes, DEN210XLInternational Air Services Inc Trustee · Carson City, NVN222WFBailey Steve · Chehalis, WAN244SPToth Douglas F · Scottsdale, AZN2615ZCalhoon John Charles · Woodinville, WAN27WDDrummond Jonathan B · Curtice, OHN2GHAbel Robert G · Williamstown, MAN308RLAulisio Anthony III · Dana Point, CAN35WD4lo Air & Land LLC · Damascus, ORN4805URice Gary B · College Place, WAN4837URegistration Pending · Kerrville, TXRegistration pendingN575AAHanson Dirk Allen · Moorhead, MNN6MDCessna 6md LLC · Englewood, FLN808RLCtr Assets LLC · Dawsonville, GAN8103ZProsser Joel R · Sacramento, CAN8106ZWilliamson Gary S · Lakeport, CAN8107ZReid Brian M · Boise, IDN8111ZSchmitts Air Inc · Enumclaw, WAN8112ZTobias Aaron C · Clearwater, KSN8123ZGray Bryan D · Colorado City, TX
Back to Cessna 210-5(205)