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.
N1711CNorthern Flyway LLC · Anchorage, AKN1712CGrant Douglas E Jr · Chubbuck, IDN1714CMoreau Aviation LLC · Wasilla, AKN1715CAerotrack Inc · Hemet, CAN1716CReidenbach John S · Kenosha, WIN17180Newby Adam M · Anchor Point, AKN1721CLemons Air LLC · Boulder, CON1722CA G Sholton Co · Wasilla, AKN1723CDi Gangi Stephen S · Spokane, WAN1724CLentz Walter E · Duncan, OKN1725CC Wolf Inc · Ord, NEN1727CCarr Richard A · Boulder City, NVN1728CMasek Lawrence J · Cuyahoga Falls, OHN1729CN8969v LLC · Anchorage, AKN1729FAllmann Mark F Trustee · Kent, WAN172AAStuart S Macpherson Dds Inc · Cardiff By The Sea, CAN1736CThompson Frank L · Weiser, IDN1737CBristol Brian P · Webster, MNN1739COpp Daniel · Anchorage, AKN1741CWitt William A · Ennis, MTN1746CGreen Gary Dale · Mccarthy, AKN1747CConatser Patrick M · Homeland, CAN174HLarsen Kevin L · Firth, IDN1751CFeaga Charles C Jr · Abbot, MEN1752CJarvis Jerry · Big Lake, AKN1755CSutton Aircraft Salvage LLC · Palmer, AKN1756CGospel Ministries International Inc · Collegedale, TNN1764CRyan Michael · Gillette, WYN1774CStol LLC · Fort Wayne, INN1781CHenkelmann David H · Janesville, WIN1785CBorns Frederick G · Chandler, AZN1787CMorris Charles W · Wasilla, AKN1789CBuxton Tracy S · Enterprise, UTN1794CAcp Aviation LLC · Oakdale, LAN1795CSchellhaas Bennett · Galloway, OHN1797CKelley Larry D · Portland, ORN18053Kraft Tyrone H · Timber Lake, SDN18055Plane Fun Inc Tr Trustee · Snellville, GAN180AHigginbottom Nathan · Cave City, ARN180ABFoster Bradley J · Wichita, KSN180AKBecker Kurt G · Dexter, NMN180BDSanderson Bryan D · Emmett, IDN180BGCmw Aircraft LLC · Hailey, IDN180BRDainas Barry · Port Orange, FLN180CBrown Hector M · Glenwood Springs, CON180CBSmith Dennis A Trustee · Salem, ORN180CRSnow Robert J · La Mesa, CAN180DProuty Edgar C Jr · Sebec, MEN180DAAalgaard Raymond F · Hollister, CAN180DFSale Reported · Anchorage, AKSale reported
Back to Cessna 180