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 ('5870220')
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 ('5870220')
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.
N222DKVestal Randy L · Darien, GAN222LTRuskin Elizabeth M · Anchorage, AKN226CHyland Nathan W · Queen Creek, AZN226CRBentley Mooney LLC · Seattle, WAN228RMSouthern Aircraft Consultancy Inc Trustee · Casper, WYN231ACHinsdale Jeffrey M · Ionia, NYN231AEJda Properties LLC · Stillwater, MNN231AFPistora Steven R Trustee · Lindsborg, KSN231AGQualitair LLC Trustee · MichelstadtN231AJFrimodig James P · San Diego, CAN231AKKab Flyers LLC · Greenville, ILN231ALBaryon Aero LLC · Culver City, CAN231APHoneyland Inc · Wolf Point, MTN231AQHenslee Christopher S · Grass Valley, CAN231ARMabry Danny W · Morehead, KYN231ASSkousen Joel M · Spring City, UTN231ATMuncy Donald A · Corinth, TXN231AURouw Bruce · Leesburg, FLN231AYDelgado Erick · Tucson, AZN231AZSpirit Aviation N231az LLC · Austin, TXN231BADykstra Darren J · Pacific Grove, CAFirst renewal noticeN231BCFlying Elite Inc · Wilmington, DEN231BDNicholls Samuel H · Brookfield, ILN231BGWojteczko Jason A · Derby, KSN231BHStefenelli Aviation N-Tr Inc Trustee · AtterseeN231BLSolethium Lc · Jonesboro, ARN231BMLee Judy K · Nashport, OHN231BNTaylor Kent S · Watford City, NDN231BRGlasco Bradley F · San Diego, CAN231BSJastrab Michael W · Apple Valley, CAN231BTAbbott Daniel · Camden, TNN231BUFlying Black Cat Aviation LLC · Saint Augustine, FLN231BVMorcott Ian · Mountain Home, IDN231BXWest Larry L · Creston, IAN231BZFortney Bradley A · Madison, MSN231CPorter Matthew · Owasso, OKN231CACross Jerry D · Panama City, FLN231CBKodiak Aviation Partners LLC · Aurora, CON231CFN231cf LLC · Dresden, MEN231CGThrash Scott H · Hesston, KSN231CHBaer Bruce E · Downingtown, PAN231CJMcgeeney Edward C Jr · Desert Hills, AZN231CKRobertson Stephen W Jr · Clovis, CAN231CPCharley Papa LLC · San Luis Obispo, CAN231CRCheavens Mark R · Georgetown, TXN231CSAdvenutre Flight LLC · Duchesne, UTN231CTVoss Kevin · Houston, TXN231CVCooke Richard Lynn · Aransas Pass, TXN231CXCruz Jesse · Simi Valley, CAN231CZPerino Louis J · Monticello, FL
Back to Mooney M20K