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 ('2072420')
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 ('2072420')
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.
N5874RHammel Tyler S · Dufur, ORN5875RHepburn Joseph C · Towanda, KSN5876RJasmer Craig G · Puyallup, WAN5877RRegistration Pending · Hardinsburg, KYRegistration pendingN5881RRengel Ronald J · Mundelein, ILN5882RGrow Aviation LLC · Aurora, NEN5886RZimmer James D · Mason City, NEN5888RTepper Steve D · Stayton, ORN5889RPatkotak Crawford A · Barrow, AKN588LCProdonor LLC · Phoenix, AZN5890RYell Christopher R · Williamsburg, KYN5891RTun Bay Inc · Wasilla, AKN5894RMurray Kevin D · Moneta, VAN5895RBernhard Sterling · Harper, TXN5896RRegistration Pending · Florence, MSRegistration pendingN5899RParrish Aviation Flight Academy LLC · Dallas, TXN5900RAidan Hammond · Ione, CAN5902RWojcik Dorene L · Cortland, OHN5905RSmart Harold J · Locust Grove, GAN5906ROlson Bradley P · Pendleton, ORN5907RBrown Kriss · Naperville, ILN5909RWagner Christopher J · Tulsa, OKN5913RWilliams Alonzo · Bentonville, ARN5914RWaldrop Charles Trustee · Oklahoma City, OKN5917RParcell Evelyn Cassandra · Norfolk, VAN5920RAmerican Eagle Aviation LLC · Flushing, MIN5927RRodrigues Robert R · Cordova, AKN5930RDownwind Corp · Brush Prairie, WAN5934RHoyt Jacob T · Oneida, NYN5935RStofer William B · Warsaw, INN5937RDavies Shane E · Kent, WAN5939RHester James T · Fayetteville, GAN5940RBakrevski Lupcho · Valparaiso, INN5941RChristian Stuart J · Erskine, MNN5942RL&L Ltd · Shoreview, MNN5943RGear Down Hangar LLC · Phoenix, AZN5944RLucas Heaven · Griffin, GAN5945RDamme Douglas A · Talmage, NEN5946RElite Aeronautics LLC · Miami, FLN5947RDillon Aero Inc · Phoenix, AZN5951RSouth Seattle Community College · Seattle, WAN5954ROtr Enterprises LLC · Broussard, LAN5960RFrame Russell C · Harrison, IDN5961RPieper James E · Corpus Christi, TXN5962RN5962r LLC · Auxvasse, MON5969RFrederick Clint A · Mattoon, ILN5971RBowers Joshua Shane · Ballston Lake, NYN5973RGrit Services LLC · Manila, ARN5975RBates Kristopher M · Zanesville, OHN5976RMeadows Robert K · Macon, GA
Back to Cessna 172G