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 ('2073709', '2073710')
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 ('2073709', '2073710')
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.
N8037GGuidry John M · Pensacola, FLN8039GGreen Mortgage Corp · Walworth, WIN8043GConnor Robert L · North Little Rock, ARN8044GTml Services LLC · The Villages, FLN8049GStone & Phillips Aviation LLC · Youngstown, FLN8050GJudge Simone · Greenwood, ARN8051GMeyer Nicholas A · Indianapolis, INN8054GPelham Robert F · Glasgow, KYN8056GYosten Patsy J · Greenville, TXN8061GMolstad Jerome M · La Crosse, KSN8062GKelly Michael · Kaneohe, HIN8067GMaley Randy J · New Philadelphia, OHN8068GStructural Design And Analysis Inc · Reston, VAN8071GBell John · Queen Creek, AZN8073GBaker Brenten E · Farmington Hills, MIN8074GBudge Ross Spencer · Colorado Springs, CON8076GGriffin Billy J · Corona, CAN8077GPhillips Stuart · La Conner, WAN8078G615dm LLC · Hazel Green, ALN8084BN8084b LLC · Fort Worth, TXN8089GWellman Steven R Trustee · Englewood, FLN8091GWood Kim W · Tucson, AZN8122LWoodward Thomas M · Granbury, TXN813JWComanche Air Inc · Tacoma, WAFirst renewal noticeN8179DGarza Jose R Jr · West Jordan, UTN81RPLull William G · Ramona, CAN8200GRj Vincent Enterprises LLC · Rancho Santa Fe, CAN8201GMetzgen Richard A · Groveland, CAN8203GWarne Samuel S · Salisbury, NCN8204GLowe Clinton V · Lake Point, UTN8207GKing Paul · Mount Holly, NJN8208GAerialscapes Inc · Hartland, WIN8209GJames Billy J II · Comfort, TXN8211GSky West Aviation Inc Trustee · Albuquerque, NMN8212GDavis Richard M · Southport, NCN8214GKolman Michael D · Overland Park, KSN8215GGersten Iron · Spring Valley, CAN8216GFarrar Edwin L · Mansfield, OHN8219GSchaum Jerome B · Machipongo, VAN8221GIshoy Glen · Indiana, PAN8224GSkylarkers Inc · Farmington, NMN8225YInternational Air Services Inc Trustee · Carson City, NVFirst renewal noticeN8227GKritz Eric J · Gualala, CAN8229GEastman Gary Lynn · Penn Valley, CAN822CGRepublic Wings LLC · Moseley, VAN8231GRad Pouria · Camarillo, CAN8235GSterling Colleen M Trustee · El Cajon, CAN8237GRegistered aircraftN8238GDavison Dennis D · Spanaway, WAN8241GSilvers Clarence W III · Holden, MO
Back to Cessna 177RG