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.
N3323DPrince Christopher E · Anchorage, AKN3327DWelborn Mark G · Boonville, NCFirst renewal noticeN3328DAcme Aircraft Leasing Mt LLC · Kalispell, MTN3329DWarren Mark W · Arlington, WAN3330DState Of Alaska · Kodiak, AKN3331DKramer Donald J · Buffalo, MNN3334DRedford Daniel A · Wasilla, AKN3335DWilson Zane D · Fairbanks, AKN3337DSmooth Air LLC · Camas, WAN3339DSale Reported · Kalispell, MTSale reportedN333QBAdams Chad D · Dayton, ORN3341DTwenty One Miles LLC · Woodland Hills, CAN3349DWeninger Gregory M · Burrton, KSN3357DHodel Lawrence E · Hayden, IDN3361DDe Lint Marcus W · Cove, ORN3363DTodd Michael E · Yelm, WAN3364DKtr Aviation LLC · Evans, CON3372DWings Like Eagles Aviation LLC · Newnan, GAN3373DCarpenter Marshall Owen · Isanti, MNN3374DScootair LLC · Alburgh, VTN3375DQualls Randy J · Claremore, OKN3376DHammond James F · Yellow Springs, OHN3380DRussell Robert J · Wasilla, AKN3382DBond Jeffrey A · Las Cruces, NMN3383DStyer Michael J · Amarillo, TXN3389DRegistered aircraftN3392DHaszard John R · Ophelia, VAN3394DCartledge Charles J · Orrville, OHN3395DFitzgerald John A Jr · Ester, AKN33GCMarble Jere D · Dayton, NVN3452DRault Jaimie E · Homer, AKN3475YAbidance Inc · Winthrop, WAN3601CLloyd Land Plane IV LLC · Brighton, CON3604CCosby Asa L · Weldon, CAN3605CChambers Joseph B · Oswego, NYN3606CHendrix Grant Mcmahill · University Place, WAN3611CNicoll Steve · Bozeman, MTN3612CLipka Will · Center Point, TXN3613CSchneiderhan Edward F · Laurium, MIN3615CMarkwardt Jacquelyn K · Santa Cruz, CAN3619CHamby Michael R · Parma, IDN3624CMeadows Marcus M · Anchorage, AKN3631CClark Mark R · Pullman, WAN3635CMckinney Steve R · Hamersville, OHN36362Sale Reported · WitshireSale reported, pending cancellationN3642CMcmahan Bryan · Gakona, AKN3643BCoffelt Kelly L · Bend, ORN3643CThompson Thomas S · Stoutsville, OHN3647CSmith Kristopher D · Wickenburg, AZN3649CBayou Flight LLC · Parker, CO
Back to Cessna 180