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 ('2075816')
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 ('2075816')
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.
N7326SState Of Alaska Department Of Public Safety · Anchorage, AKN7328NPersonal Fliers Inc · Sterling Heights, MIN7328SVersa Wings LLC · Port Saint Lucie, FLN7329QBooker Merle D · Connell, WAN7329SMoncourtois Mark T · Annandale, NJN7330SNew Heights Aviation LLC · Decatur, TXN7331NLost Creek Aviation LLC · Elkhorn, WIN7331QKelly Timothy K · Dassel, MNN7331SAzizi Habib E · Franklin, TNN7332SSmith Enterprises Inc · Grangeville, IDN7333QMac Neill Malcolm G · Lake Junaluska, NCN7334QHurri-Clean LLC · Brewton, ALN7334SKcsi Aerial Patrol Inc · Bakersfield, CAN7335QStaas Justin W · Sacramento, CAN7336NRoberts Frederick · El Segundo, CAN7336SAerospace Trust Management LLC Trustee · Wilmington, DEN7337NSpitfire Aviation Inc · Wilmington, DEN7338QBotts Eugene J · Rosenberg, TXN7338SFielding Kenneth G · Missoula, MTN7340SDiamond K Rentals LLC · Tucson, AZN7341QHahn John C · Sherwood, ARN7342QThistlesoar LLC · Plaquemine, LAN7345QLester Darrell S · Riverton, UTN7346SWood Donald · Spring Branch, TXN7347QMitchell David L · Imperial, TXN7347SRegistered aircraftAssigned, pending cancellationN7350SObrien Timothy K · Huntington Beach, CAN7354NGilleland Earl C · Oakwood, GAN7354QRegistration Pending · Austin, MNRegistration pendingN7354SHobbs Meeks Victoria · Miami, FLN7356SSnohomish Flying Service Inc · Snohomish, WAN7358NHnat Peter Paul · Foresthill, CAN7358SHittle Thomas W · East Haven, CTN7360QNavolutions Inc · Pleasanton, CAN7360SSsk Ventures LLC · Eagle, CON7361NWilcox Aerial Applications Inc · Tilden, NEN7362SRegistration Pending · Colleyville, TXRegistration pendingN7363NDef Air LLC · Buchanan Dam, TXN7363QTyleranna Adventures I LLC · Boerne, TXN7363SCoral Air LLC · Rock Rapids, IAN7365SNorthgate Aviation Inc · Chico, CAN7366QScheidt Eric D · Columbus, INN7367SCentral Plains Aero LLC · Wichita, KSN7369SBlue Skies Aviation LLC · Gig Harbor, WAN7370SNewman Carlon Keith · Cypress, TXN7371NBradley Larry · Olustee, OKFirst renewal noticeN7371QHarbor Aviation LLC · Harbor Springs, MIN7371SJacobson Justin D · Fallon, NVN7373NPyne Jeffrey S · Spanish Fork, UTN7373QMidgette Damon · Santa Clarita, CA
Back to Cessna 182P