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 ('2072702')
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 ('2072702')
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.
N5620BBend Aircraft Rentals LLC · Bend, ORN5621BArtz James R · White Bird, IDN5627BTaylor Tona R · Graham, WAN5630BJohnstone Karl S · Anchorage, AKN5631BZufelt Robert H · Nampa, IDN5632BPasahow David R · Fredericksburg, TXN5638BBowman David R · Julian, NCN5640BN5640b LLC · Ashburn, VAN5641BGoebel William R · Rhome, TXN5644BSchmidt Ross A · D-63329 EgelsbachNon-citizen corporation, flight hours not reportedN5645BHenderson William R · Ohatchee, ALN5646BSkydive Ky LLC · Cecilia, KYN5648BBailey Carl · Huntington, WVN5650BPlane Life LLC · Wilmington, DEN5653BKey Jon · Seminole, TXN5658BSheyman Igor · Danville, CAN5659BAom Aircraft LLC · Wilmington, DEN5660BHarlow Brett · Pryor, OKN5661BPiekarski John G · Kuna, IDN5662BHollibird Aviation LLC · Knightdale, NCN5666B98x LLC · Caddo Mills, TXN5667BMarmitt Management Inc · Moses Lake, WAN5670BHart Deric C · Anchorage, AKN5671BVaughn William · Charlotte, NCN5672BToumala Scott R · Bemidji, MNN5675BMontgomery Richard G · Garden City, IDN5677BHope Aviation LLC · Hope, IDN5680BTveitnes Svein T · Whitewright, TXN5687BOsojnak Keith J · Cottonwood, UTN5688BJordan Bros · Centre, ALN5694BKrukow Jonathan L · Hampton, IAN5696BSkyways Group · Albuquerque, NMN5698BTilley Melvin D · Sperry, OKN5704BTveitnes Svein T · Whitewright, TXN5710BNampa Aviation Holdings LLC · Boise, IDN5711BVtoss Holdings LLC · Anchorage, AKN5716BHare Alison S P Trustee · Grass Valley, CAN5718BKlingler Lawrence R · Wolfeboro, NHN5719BAdventures In The Sky Aviation LLC · Fresno, CAN5722BVelasquez Benjamin · Anchorage, AKN5726BBend Aircraft Rentals LLC · Bend, ORN5728BHawkins Charles A Sr · Chillicothe, OHN5733BRobertson Nate Allen · Aiken, SCN5740BPash Olin M · Harlan, IAN5741BCansino Ross G · George West, TXN5744BMcgrew Robert P III · Red Bluff, CAN5747BFarris Steve R · Fresno, CAN5751BMacon Michael D · Sisters, ORN5752BWallace Thad Joseph · Mount Shasta, CAN5756BWages Brent · Rupert, ID
Back to Cessna 182