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.
N52195Cabane Marcelo J · Miami, FLN52465Clutter Mark R · Spencer, OHN52476Good Guys Flying Club LLC · Colorado Springs, CON52489Cardinal Club Llp · Fargo, NDN52493Lasky Matthew T · Constable, NYN52497Hobar Geoffrey · Hoffman Estates, ILN52543Berry Curtis L · Williamsport, MDN52578Wall Leslie A Trustee · Stevensville, MDN52579Urquhart David L · Winchendon, MAN52582Wheeler Kevin K · Thornville, OHN52585Colley Reid W · Pauls Valley, OKN52589Audritsh John E DBA · Indianapolis, INN52604Harding Marc S · Des Moines, IAN52612Daniels Willie L II · Castle Pines, CON52619Lardin William A · Thomasville, GAN52634Beck Gary F · Cypress, TXN52636Macdonald Russell K · Richmond Hill, GAN52640Crawford Bill E · Hayti, MON52643Cardinalrg LLC · Ballwin, MON52647Berling David · Litchfield Park, AZN52660Yancey Steven Hunter · Helenwood, TNN52662Aston Stuart A · New Braunfels, TXN52663Registration Pending · Cedar Key, FLRegistration pendingN52667Noe Daniel P · Pittsburgh, PAN52669F Sharp Aviation LLC · New Baltimore, MIN52680Harris John Q · Tucson, AZN52684Altair Advanced Industries Inc · Bellingham, WAN52695Farley Ryan P · Cumberland, RIN52696Sladko Jeffrey · Battle Ground, WAN5269DGeorges Aviation Services Inc · Honolulu, HIN526BBBrookover James R · Hartville, OHN52713Austin-Walker Aviation LLC · Waukee, IAN52716Brewer Wesley G · Irvine, CAN52719Pynn David W · Gasport, NYN52723Southern Aircraft Consultancy Inc Trustee · Casper, WYN52765Benson Daniel P · Lake Placid, FLN52786Moore Roger · Jonesboro, ARN52791Gibson James W · San Antonio, TXN52800Jackson Royalties Inc · Brandon, MSN52802Gune Abhijit P · Dublin, CAN52805Conover Mark D · Santa Cruz, CAN52814Hyduke Robert Alan · Port Matilda, PAN52823Sloop Danny H · Rockwell, NCN52825Thomas James C · Elkhorn, WIN52828Jacobson Marc A · Madison, WIN52831Truck Guy Inc · Coweta, OKN52838Benham Aviation LLC · Enid, OKN52839Cardinal Flyers LLC · Farmington, MON52851Mcnamee Brian E · Pompano Beach, FLN52862Klosterman Sean M · Seattle, WA
Back to Cessna 177RG