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.
N6325APrestegard Michael L · Delta Junction, AKN6326ANipper Melanie T · Defuniak Springs, FLN6327ASmith Mathias N · Weiser, IDN6328AHsd&R Enterprises Inc · Abilene, TXN6329AAlpine Medical Services Inc · Hayden, IDN6330BGroup Therapy Enterprises Inc · Claremore, OKN6332ASkydive Awesome! LLC · Bend, ORN6333AHeller Peter C · Denver, CON6337AAilf Marketing LLC · Port Charlotte, FLN6338ALittle Bird Airways LLC · Hamburg, NYN6339AHockenberry Tyler F · Royse City, TXN6341APattison Jeffrey L · Glasgow, MTN6344AAvery Timothy · Payette, IDN6345AMoss Gary · Bend, ORN6346ASkydive Operator Aircraft Rentals LLC · Ithaca, NYN6353ACypress Soaring Inc · Hemet, CAN6356AFetterolf Zachary D · Athol, IDN6358ATop Aircraft Leasing LLC · Wilmington, DEN6359ASutton Aircraft Salvage LLC · Palmer, AKN6360AClaiborne Howard · Cottonwood, CAN6363AWong Adrian Trustee · San Francisco, CAN6366AHunsaker Travis J · Salem, ORN6367AFritz Mathew L · Boise, IDN6371ADo Enterprises LLC · Port Charlotte, FLN6379AReichlinger Gary · York, NEN6382AMuellner Peter M · Bigfork, MTN6383AGardner Frankie J · Mount Vernon, ARN6392ARlf Aviation LLC · Peachtree Corners, GAN6393ALadmill Investments LLC · Gulfport, MSN6395ARose City Soaring Association Inc · Valdosta, GAN6399AAllen Sam P · Poulsbo, WAN6410ANichols John W · Post Falls, IDN6415APekkala John W · Palmer, AKN6416AJanak Jeffrey · Corpus Christi, TXN6417ALevasseur Peter W · Plymouth, MEN6420AAbidance Inc · Winthrop, WAN6421AAllen Khaled Charles · Berkeley, CAN6422AColby Clayton L · Kalispell, MTN6426AAmes Todd · Millington, MIN642WRN642wr LLC · Henderson, NVN6430ATulsa Technology Center School District No 18 · Tulsa, OKN6433AWagar Dennis Murphy · Marion, MTN6437ATwin Oaks Aircraft Maintenance LLC · Hillsboro, ORN6438AP M Leasing Inc · Perris, CAN6442ABalderston Jessika A · Ronan, MTN6443AStartin Matthew R · Colfax, WAN6452ARansom Bradley D · Flagstaff, AZN6453ALight John William · Anchorage, AKN6458AStebbins Robert B · Georgetown, TXN6463ABiocca Richard · Tucson, AZ
Back to Cessna 182