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.
N666RJNewitt David C · Oakland, CAN678GHHamilton Gilbert R · Leesburg, VAN690TSMartin Tony A · Kingwood, TXN691DBRvrh Ventures LLC · San Antonio, FLN696CBWhitmire Aviation LLC · Saint Augustine, FLN69RMDicicca Yolanda L · BitontoN6BEZephyr Enterprises Inc · Wilmington, DEN6FVAlexis Asplundh Studio LLC · Atlantic Beach, FLN700CDCrahen William F · Merrimac, WIN707CGMohler Mark R · Green Cove Springs, FLN710FGKimbrell Jeffrey L · Greenville, SCN711ZHappenstance LLC · Cabot, ARN727LBMcnamee John B · Sugar Land, TXN731TXRegistration Pending · Harrah, OKRegistration pendingN737WPAeroworks Productions LLC · Kenosha, WIN73ALHefel Lori A · Wichita, KSN74177Campbell Peter Shane · Knoxville, TNN747MLMaxwell Robert C · Fountain Hills, AZN74SSPelletier Kevin C · Williamsport, MDN7502VBluewater Bay LLC · Ardmore, OKN7503VChuga Gregory M II · Hayes, VAFirst renewal noticeN7504VImage Craft LLC · Phoenix, AZN7505VSky West Aviation Inc Trustee · Albuquerque, NMN7515VRxair 2 Inc · Bella Vista, ARN7516VOgletree Ben R Jr · Livingston, TXN7517VSims Albert Paul · Auburndale, FLN7521VLeslie Warren J · Sequim, WAN7523VTwc Aviation Services LLC · Merritt Island, FLN7530VNicolaou John G · San Ramon, CAN7533VWilliams Jeffrey D · Sparta, NJN7534VCardinal Aero Group LLC · Marshall, ARN7535VSchneider Martin G · Milford, NEN7536VBas Part Sales LLC · Greeley, CON7537VHorizon Aeronautics Inc · Columbia, SCN7538VLee Walker S · Searcy, ARN7542VCoastal Cosmetic And Implant Denistry LLC · Miramar Beach, FLN7544VGavazzo Victor Grille · Saint Peters, MON7550VGamblin Elton Berry · Vienna, VAFirst renewal noticeN7554VOlson Nicholas W · Copper Canyon, TXN7555VWallen Bruce R · New Britain, CTN7556VWennerstrom Kirk · Norwalk, CTN7557VTexas Dentco LLC · El Paso, TXN7558VSisk James G · Coppell, TXN7559VNorton Lyle K · Coquille, ORN7565VRehwald William J S · Santa Monica, CAN7568VPawlish Andrew M · Fort Collins, CON7569VLiberty Capital LLC · Kalispell, MTN7571VRothstein Tim P · Litchfield, MNN7572VOffshore Services Ltd · Block Island, RIN7573VOlson Jerome W · Kerrville, TX
Back to Cessna 177RG