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 ('8682000')
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 ('8682000')
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.
N51ULN2439b Associates LLC · Virginia Beach, VAN51YLTbm 330 Inc Trustee · Wilmington, DEN522ATHedley Kenneth G · Glen Ellyn, ILN525WGUp In The Air LLC · Hickory, NCN535DMKcd Air LLC · Tonica, ILN544MDMbt Administration LLC · Alpine, WYN545WBLamy LLC · Alexandria, LAN54EC400 Knot Aviation LLC · Granbury, TXN551MATwo Fives LLC · San Diego, CAN555HP8992 Air LLC · Whitman, NEN555TQSpats Aviation LLC · Toledo, OHN559CASky West Aviation Inc Trustee · Albuquerque, NMN55LYHely Fly Inc Trustee · Wilmington, DEN561TBPembrook Aviation LLC · Los Angeles, CAN562AWElbon John W III Trustee · Sedalia, CON565CVJag Capital Holdings LLC · Winnetka, ILN56WFCatterall Nigel Grant · Sugar Land, TXN576MAMeru Aviation LLC · Gibson City, ILN579NKontek Industries Inc · Kannapolis, NCN57LDHinckley Montana LLC · Reno, NVN580MABigskytoabaco LLC · Helena, MTN581MD21 Full Send Aviation LLC · Waukee, IAN585GCD&G Aviation LLC · Denver, CON590JLVincent Valuations LLC · Merry Hill, NCN599GBuford John B · Memphis, TNN59PVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN59XTBlue Sky Operations LLC · Carmi, ILN5HTHigh Calling LLC · Golden, CON5JRBreckenridge Aviation LLC · Fort Smith, ARN5KCTvpx Ars Inc Trustee · North Salt Lake, UTN601AC20th Century Homes Inc · Hopkinton, MAN607JMDelta Aviation LLC · Lamoni, IAN615TXHappybay LLC · Traverse City, MIN616CMEirecorp Corporate Aviation Inc Trustee · Wilmington, DEN622MAMarkle Aviation LLC · Wilmington, DEN625FSAg Solutions Group Intermediate Corp · Chickasha, OKN626DMStraight Aero LLC · Cleveland, OHN6272BH&S Aircraft Holdings Inc · Hazelwood, MON62LMBroadway Air LLC · Huntsville, ALN636MAKourakos William Jr Trustee · Coral Gables, FLN639CWPb Air LLC · Americus, GAN63TPHot Air LLC · Cambridge, MAN650DMMaroon Creek LLC · Aspen, CON651WBContrail Inc · Bethlehem, PAN654CWRivercity Aviation LLC · Coeur D Alene, IDN656LDWin Up Inc · Cookeville, TNN656WConn Aviation LLC · Millersburg, OHN657MAKtnc Leasing LLC · Lexington, KYN661EKGi Aviation LLC · Denver, CON667CAYintash Aviation LLC · Seminole, TX
Back to Socata TBM 700