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 ('2072704')
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 ('2072704')
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.
N5968BLawrence Jon D · Williamsburg, MIN5983BNck Consulting LLC · Scottsdale, AZN5988BLarsen Christopher S · Pleasanton, CAN5995BWilson Robert E III · Urbanna, VAN5996BStrong Brian S · Southport, NCN5997BSpence Joseph H · Enterprise, ORN5998BConroy Bruce M · Martinez, CAN5999BBig Bird LLC · Prescott, AZN6002BWard William O · Pocatello, IDN6003BHenley Alan · Hoover, ALN6005BConnected Air LLC · Danvers, MAN6006BRockfield Investments LLC · Hurricane, UTN6007BSkydive Deland Inc · Deland, FLN6008BKarella Howard · Fairbanks, AKN6010BSwanson Paul W · Turlock, CAN6017BBarrett Daniel E · Augusta, MTN6018BMcgrath Robert J · Simpsonville, SCN6019BHaderlie Dustin D · Afton, WYN6022BArpino James E · Fairbanks, AKN6025BBetter Air Service LLC · Dailey, WVN602BBHeinke Jon B · Seymour, WIN602WPKilpatrick Matthew R · Baton Rouge, LAN6031BPizzato Alberto · Gresham, ORN6036BSanders Trent · Redway, CAN6040BErickson Keith D · Carver, MNN6041BNewell Scott A · Seeley Lake, MTN6042BWilson Janis O · Friendswood, TXN6047BOliver Ross C Trustee · Eagle River, AKN604MSHawaiian Airlift Company Llp · Kihei, HIFirst renewal noticeN6051BGmr Leasing LLC · Lincoln, DEN6069BPlane Jane Inc · Berlin, MDN6070BLongley Tracy C · Stephenville, TXN6072BTrico Mechanical Company Inc · La Fayette, GAN6074BYount Lawrence F · Shelton, WAN6076BBouchard Timothy · Valdez, AKN6079BRift LLC · Union, MON6087BAzure Farms Inc · Dufur, ORN6089BValentine Terence S · Glennallen, AKN6091BMcmurry Andrew Clinton · Sandy Hook, MSN6092BKeenan Michael John Trustee · Anchorage, AKN6097BBenavidez Robert · Deming, NMN6098BMarranca James · Buffalo, NYN6099BWilson Stuart · North Franklin, CTN6101BRegistered aircraftN6106BBeck Brooks R · Spearman, TXN6108BBuchner George E · Nye, MTN6109BTony Flies Inc · Sparta, NCN6110BRansom Bradley D · Flagstaff, AZN6119BHeart Mountain Aviation Services LLC · Knoxville, IAN6120BSmith Richard D II · Luthersville, GA
Back to Cessna 182A