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.
N819LMAer 1121 LLC · Naples, FLN81MJMorrow Aviation LLC · Midland, TXN81YYAircraft Partner Holdings Inc Trustee · BerlinN828DDN828dd LLC · Klamath Falls, ORN82MAPdmi Client Sales Support LLC · Poland, OHN835CAHill David C · Lancaster, NHN836EAPella Assets LLC · Natchez, MSN838GKInternational Air Services Inc Trustee · Carson City, NVN838RAT206 Aviation LLC · Stockton, CAN842CARich Valley LLC · Groton, MAN842MABbns2 LLC · Mooresville, NCN843BHGaylord Theodore Scott DBA · La Grange, CAN847MCCanoecouple Inc · Winnetka, ILN84HSGc N84hs LLC · Layton, UTN850AAPsi Star Aviation LLC · Chattanooga, TNN850ABFirefly Consulting LLC · Wausau, WIN850ADN850ad LLC · Jonesboro, ARN850AGSeventh Letter Capital LLC · Oxford, MSN850AHSchell Brothers II LLC · Rehoboth Beach, DEN850AJAj Air Ltd · Massillon, OHN850APBurns Nicholas J III · Almond, WIN850AVM&M Aviation LLC · Sacramento, CAN850AXRerops Transport LLC · Oakley, KSN850AZSalt River Aviation LLC · Sagle, IDN850BAB & A Adventures LLC · Clearwater, FLN850BDColumbia Aircraft Sales Inc · Groton, CTN850BGWren Aviation Inc Trustee · Wilmington, DEN850BLRockmount Aviation Inc Trustee · Wilmington, DEN850BTCardinal Roots LLC · Middletown, DEN850BXPro Water Solutions LLC · Henderson, TXN850BZAm Trans 731 LLC · San Antonio, TXN850CAQualitair LLC Trustee · MichelstadtN850CEAda Coca-Cola Bottling Co · Ada, OKN850CFLily Loubean LLC · Gary, INN850CGTravel Solution LLC · Terre Haute, INN850CSBeaver Air LLC · Houston, TXN850DDDella Costa Jorge · Houston, TXN850DKTexoma Industries Of Graham LLC · Graham, TXN850DTAtlas 850 Wp LLC · Chattanooga, TNN850DXMonteiro Aviation LLC · Newark, DEN850EValiair Lc Trustee · Casper, WYN850EDTachys Aviation LLC · Austin, TXN850EESpeedhawk Aviation LLC · Rancho Santa Fe, CAN850ELErickson Logging And Construction Inc · Gig Harbor, WAN850FNDm Advisors Inc · Garland, TXN850FPBrical Enterprises LLC · Belton, MON850GHKcc Av LLC · Fayetteville, ARN850GMMannup LLC · Jasper, INN850GSInternational Air Services Inc Trustee · Carson City, NVN850GVN850gv LLC · Austin, TX
Back to Socata TBM 700