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 ('2072418')
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 ('2072418')
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.
N707UJInternational Air Services Inc Trustee · Carson City, NVN709PTCappe Investment Group LLC · Homestead, FLN70DMMl Flight Services LLC · Miami, FLN713JKSbarounis Carl A · Torrance, CAN71409Piedmont Flight Inc · Winston Salem, NCN71430Princeton Raptors Flying Club · Princeton, MNN71444Rushville Flying Club Inc · Rushville, ILN71501Boone William G · Orland, CAN717CEHuffman Jacob M III · Burleson, TXN71PKBob Hoover Academy · Salinas, CAN722AARobinson Charles F Jr · Portage, MIN724TMMorcom Aviation Services Inc DBA · Everett, WAN724TXStratus Aviation LLC DBA · Vacaville, CAN725ECDraco Flight School Inc · Chino, CAN727RCKelley Aircraft LLC · Weyers Cave, VAN727TSStreng Terry E · Columbus, OHN72884Hawkeye Aviation LLC · Miami, FLN72CCCaterfull Inc · Miami Beach, FLN72FDEngesath David H · Duluth, MNN72JNTroy I Mounts Md Inc · San Juis Obispo, CAN73001Spooter Air LLC · Obion, TNN73010Rico Aviation Services Inc · Miami, FLN73015Alameda Flying Club Inc · Richmond, CAN73020Ajf Enterprises LLC · Des Moines, IAN73028Halley Craig H · Lanai City, HIN73040Goulding Brian K · Roswell, GAN73041Max Air Aviation LLC · Carrollton, GAN73043Six Ten Ventures LLC · Cedar Hill, TXN73054Blue Wings LLC · Spokane, WAN73063Oregon State Flying Club · Corvallis, ORN73064Whitelam Bruce R · Sacramento, CAN73068Christensen Gary D · Alliance, NEFirst renewal noticeN73069Eagle Sky Patrol Inc · Deadwood, SDN73091Rudder33 LLC · Grantham, NHN73093Yngsdal Dale A · Lino Lakes, MNN730HAHonaker Group LLC · Sellersburg, INN730LBEarly Bird Aviation LLC · Rillito, AZN73103Bfl Aviation LLC · Bakersfield, CAN73105Jlk Management LLC · Kerrville, TXN73113Top Flight Aviation Inc · Corona, CAN73116Taildraggers Flyers Inc · Saint Joseph, MIN73131Fremont Flight Academy LLC · Fremont, OHN73134Harborside Aviation Services Inc · Punta Gorda, FLN73146Oregon State Flying Club Inc · Corvallis, ORN73148Kinney Transportation · Columbia, MON73149Good Flight Aviation LLC · Stockton, CAN73151Hawaii Aviators LLC · Ewa Beach, HIN73154Bishop Services LLC · Ellisville, MSN73170Jahawk Leasing LLC · Sugar Grove, ILN73171Jettmar Rainer U · Washington, DC
Back to Cessna 172M