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 ('2073456')
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 ('2073456')
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.
N6606YBlackwell Benjamin D · Scottsdale, AZN6614YBoots LLC · Clay Center, KSN6617CN6617c Inc · Calumet City, ILN6621AJc Investors Group LLC · Coral Springs, FLN6622CMidnight Flight LLC · Wells, TXN6622YSierrakilo LLC Trustee · Lewes, DEN6638NIsr Aviation LLC · Wilmington, DEN6661NSmith Joel L · Cedar Park, TXN6667NSmith William F · Hindsville, ARN6686NClarity Aviation LLC · Anchorage, AKN6688NLedson Steven Noble · Sonoma, CAN6694NGear Down LLC · Dalhart, TXN673DKBh Aero LLC · Hanover, MNN67CHPrestige Aviation LLC · Lake Havasu City, AZN6808NSwan Air LLC · Perham, MNN685GTEatmb Air Inc Trustee · Wilmington, DEN68MGDreger Dean R · Wilbur, WAN68TBSmith Ronald A · Los Gatos, CAN6939NSky West Aviation Inc Trustee · Albuquerque, NMN6967NSand Creek Oil & Gas Inc · Edmond, OKN6970NSeitz Thomas J · Mission, KSFirst renewal noticeN6972NEnns Robert B · Cayucos, CAN6976NCenturion Capital Partners LLC · Blue Ash, OHN6979NArango Jorge · Mcallen, TXN6993NSp Aircraft LLC · Moscow, IDN69WAKeystone Aerial Surveys Inc · Philadelphia, PAN701MDDel Mar Aviation LLC · Algona, IAN7213NSouth Aero LLC · Albuquerque, NMN722ELBristow Bryan M · Albany, ORN722RRAncira Autos LLC · San Antonio, TXN7250NSimon Jevon · Buckley, WAN727WSRobey Sean C · Camden, NCFirst renewal noticeN7303NJordan James D · Paradise, TXN7329NRegent Trust Corp Trustee · Wichita, KSN7335NEnrique Elias Luis · Chandler, AZN7336CDelta Kilo Av8 LLC · Bonita Springs, FLN7357CPerson Donna Mae · Columbus, NEN7384CFesco Holdings Inc · Alice, TXN7389NKns Properties · Perry, IAN746ZXSlater R Winston Trustee · St Charles, ILN7591NJones Michael D · Southern Pines, NCN7599NAir Conejos Inc · El Paso, TXN75DAHenderson John L · Ozona, TXN75RCJoffe Zalman · Bahama, NCN761CWOne Charlie Whiskey LLC · Austin, TXN7685NFranklin Construction Inc · Chico, CAN777BMJet Air Of South Florida Inc · Deerfield Beach, FLN77RASky West Aviation Inc Trustee · Albuquerque, NMN79RCBach II LLC · Lafayette, LAN7ALFlying Fortress Of Swfl LLC · Fort Myers, FL
Back to Cessna T210N