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 ('2072431')
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 ('2072431')
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.
N736DVBradford William O Jr · Huntersville, NCN736EBTesta Sam C · Bonners Ferry, IDN736ECBailey Mark H · Bluffton, SCN736EDSelwyn Rebekah L Trustee · Eastsound, WAN736EFWalding Grant L · Coos Bay, ORN736EGMoore Samuel R Jr · Tabernacle, NJN736EHGarvin Lee E · Brookings, ORN736EJDodson International Parts Inc · Rantoul, KSN736EMPerez Carlos E · Bayshore, NYN736EQHarper Henry A · Mesquite, NVN736ESRainbow Aviation Services · Kingsville, MON736ETSchuler Darrell II · Bridgeport, NEN736EUSolano Aircraft Maintenance LLC · Torrance, CAN736EVRogerson James H · Chandler, AZN736EXHolt Aviation LLC · Clear Lake, IAN736FADebold Denise S · Spring, TXN736FBNimbus 2000 LLC · Farmington, UTN736FCJrm Wings LLC · Farmington, UTN736FDKing Brad C · Langley, WAN736FFNorkunas Lisa M · Fontana, CAN736FGJ M Carrigan LLC · Sanibel, FLN736FJHartwick Kevin D · Crescent City, CAN736FNWilliamson Thomas M · Southport, NCN736FSRussell Larry B DBA · Union City, TNN736FTChoice Aviator LLC · Chandler, AZN736FVDel Rio Advisors LLC · Modesto, CAN736FXKelcy Wyman O · Early, TXN736FYPhydeaux Aviation Ltd · Spartanburg, SCN736GAPlane Jane Aviation LLC · Sylvania, GAN736GBSilva Monico · Albuquerque, NMN736GCSilvers Morris · Burnsville, NCN736GDPactolus Investments LLC · Blounts Creek, NCN736GGLedocq Melissa A · Green Bay, WIN736GHTriple R Flying · Monticello, IAN736GJRyan Transfer Inc · Tilden, NEN736GKOrten Steven S Md · Dallas, TXN736GNMorrison Scott W · Kokomo, INN736GUFaria Farms Inc · Tipton, CAN736GVChristiansen Drilling Inc · Ely, NVN736GWMartin Stephen E · Pampa, TXN736GZJust US Air LLC · Bradenton, FLN736HATurner Daniel A · Paragould, ARN736HBZero-To-1500 LLC · Tacoma, WAN736HDGuthrie John Alex · San Ramon, CAN736HGMcclure Richard A · Victoria, TXN736HMAir Force Academy Aero Club · Usaf Academy, CON736HNRegistration Pending · Orange Grove, TXRegistration pendingN736HSHodgskiss Ben · Choteau, MTN736HWInvestair LLC · Conway, ARN736HZBird Chad W · Santa Ana, CA
Back to Cessna R172K