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.
N5357BSewellfarm LLC · Thaxton, MSN5358BMidwest Air Services Inc · Ray, MIN5359BLebbon Lee T · Annville, PAN5361BSkydive Ricks LLC · Petersburg, OHN5364BWest James L · Roswell, NMN5368BGachis Gary Allen · Vacaville, CAN5379BBtp Inc · Missoula, MTN5380BGroll Michael · Logan, UTN5382BBook Paul A · Richvale, CAN5384BGust Dale A · Boise, IDN5386BTop Dogs LLC · Dickinson, NDN5388BBurak Steven W · Emmett, IDN5395BRosecrans Robert Michael · Emmett, IDN5396BGreene County Sport Parachute Center Of Ky Inc · Loretto, KYN5400BRegistered aircraftN5402BFiehler Vernon D · Auke Bay, AKN5407BSutton Aircraft Salvage LLC · Palmer, AKN5408BLeonard James A · Boise, IDN5410BOklahoma Soaring Association · Mustang, OKN5411BBailey Carl D · Huntington, WVN5417BKnutson Wayne R · Thompson, NDN5422BR & R Aviation LLC · Arnaudville, LAN5423BBeck Skydiving & Rigging LLC · Bixby, OKN5425BEslinger Beau T · Tucson, AZN5427BYeary Clifton K · Quitaque, TXN5431BRi Skydiving Aircraft LLC · Middletown, RIN5432BDixon Charles W · Brookhaven, MSN5433BBlue Moon Aviation LLC · Grangeville, IDN5435BMacomber Gregory S · Kalamazoo, MIN5438BMoore Ryan T · Nampa, IDN5440BCline Thomas E · Santee, CAN5441BFour One Bravo LLC · Piedmont, SCN5445BWilds Terrance L · Grand Rapids, MIN5446BDavis Elizabeth · Flagstaff, AZN5448BDesjardins Norman W · Gresham, ORN5450BKunz George M · Bakersfield, CAN5453BGoggans John L · Mansfield, MON5457BBg Family Lp · Edinburg, TXN5459BBonnell Aaron K · Orland Park, ILN5465BFischer Alfred M DBA · Genoa City, WIN5467BSwank Michael G · Shreve, OHN5468BCullinane Patrick J · Pasco, WAN5469BDo Enterprises LLC · Port Charlotte, FLN5471BLowenstein Jeffrey · Juneau, AKN5473BWalsh David P Jr · Macon, GAN5477Hudson Lake Properties LLC · Pryor, OKN5482BWetzel Ryan M · Midland, MIN5484BUnwrapped LLC · Dover, DEN5485BSutton Aircraft Salvage LLC · Palmer, AKN5486BVerhaaren Inc · Naples, FL
Back to Cessna 182