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 ('2072738', '2072739')
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 ('2072738', '2072739')
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.
N516TCVan Bortel Aircraft Inc · Arlington, TXN5179BCorporate Flight Intl LLC · Glenwood Springs, CON5188BRegier Tom · Dinuba, CAN5189DRiverside Pipe LLC · Farmington, NMN5190AArias Antonio · Lakeway, TXN5193MTar Pit Investments LLC · Austin, TXN5195UChi Aerospace Inc · Portsmouth, NHN5196KMiller Andrew Howard · Granbury, TXN5198GConaway David L · Las Vegas, NVN5205UVoloshin Vitaly Alexandrovich · Seattle, WAN5209FMidwest Avtech Inc · South Barrington, ILN5209POliver Dennis L · Williamsburg, IAN52128Glasslane LLC · Wilmington, DEN5222GHanger C16 LLC · Pinckney, MIN5225YGarret G Enterprises LLC DBA · Lakewood, CON522RARaven Aircraft LLC · Prescott, AZN5236UVan Bortel Aircraft Inc · Arlington, TXN5236VT And G Investments LLC · Gulfport, MSN5237YWerninghaus Karla I · Reno, NVN5238HGalatians182 LLC · Kalispell, MTN5241SHpt Aero LLC · Longboat Key, FLN5242NDonnelly Donald Dean Trustee · Tyler, TXN5242URegistered aircraftN5243TBayley Inc · Henderson, NVN5244QVan Bortel Aircraft Inc · Arlington, TXN525MJCohen Heath P · Lake Havasu City, AZN5262QReinhart Gregory D · Waunakee, WIN5264RHenslee Aviation LLC · Hobbs, NMN52657Honeycutt Holdings Inc · Charlotte, NCN52715Echo Sierra 54 LLC · Hagerstown, MDN5271FUnverfehrt David C · Ocala, FLN5275CRamaswamy Ashok · Clearwater Beach, FLN5276YPadlock Ranch Co · Ranchester, WYN5289HClarke Simon P · Seattle, WAN528LSYoung Robert A · Mount Desert, MEN529PTLt Express LLC · Carson City, NVN53098Carlson Robert A Trustee · Rosamond, CAN5327UJa Williams Investments LLC · Austin, TXN53291North Country Aviation Service LLC · Lewes, DEN5330AGila Aviation LLC · San Luis, AZN5334KGlen Dale L · Ferndale, WAN5341GRyno Works Inc · Mccall, IDN5349HAviation Advisor Inc · Kenosha, WIN5363QCary Gosney Crna Inc · Sonora, CAN536DDHughes Jacob · Denver, CON538CPCivil Air Patrol · Maxwell Afb, ALN539CPCivil Air Patrol · Maxwell Afb, ALN542CPCivil Air Patrol · Maxwell Afb, ALN544KGDawson Aircraft Inc · Clinton, ARN553HCHotel Charlie LLC · Dallas, TX
Back to Cessna T182T