Bas Part Sales LLC
Registered aircraft · 386
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'BAS PART SALES LLC' OR list_contains(g.other_registrant_names, 'BAS PART SALES LLC') ORDER BY g.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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'BAS PART SALES LLC' OR list_contains(g.other_registrant_names, 'BAS PART SALES LLC') ORDER BY g.n_number
Run 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.
N107JFIndus T-211 THORPEDO · S/N 0705D0303N1085WMooney M20M · S/N 27-0043N11379Cessna 206H · S/N 20608077N115FPColumbia Aircraft Mfg LC42-550FG · S/N 42552N1161FCessna 172G · S/N 17254756N1167JMooney M20K · S/N 25-0690N1176RCessna 182T · S/N 18281688N118GBBeech C24R · S/N MC-582N122LJCorporate Jets BAE 125-800A · S/N 258239N123CECessna 210L · S/N 21061054N123WJMooney M20J · S/N 24-1620N1240GCessna 310Q · S/N 310Q1091N128ELLee JA30 SUPERSTOL · S/N JA386-06-14N1314GCessna 310Q · S/N 310Q1154N131HLPiper PA-46-600TP · S/N 4698131N1320WMooney M20E · S/N 208N133SRNew Piper PA-46-500TP · S/N 4697114N14379Piper PA-23-250 · S/N 27-7304970N1460PPiper PA-23 · S/N 23-523N14QBHonda HA-420 · S/N 42000107N14SSPiper PA-34-200 · S/N 34-7770385N151MMPiper PA-28-151 · S/N 28-7715129N151SRCirrus Design SR22 · S/N 2151N153PPCessna 182Q · S/N 18266340N1591QCessna 150L · S/N 15072891N159RJCessna 177B · S/N 17702038N160CRBeech 60 · S/N P-24N1652TCessna 414 · S/N 414-0432N1690LCessna 172S · S/N 172S10620N170RHCessna 170 · S/N 18030N172BXCessna 172G · S/N 17254216N1739KLuscombe 8E · S/N 4466N1748WBeech E-55 · S/N TE-887N1758UCessna T207 · S/N 20700358N177VSCessna 177RG · S/N 177RG0327N179VPSmith Miniplane DSA-1 · S/N 1N17ABCessna 210A · S/N 21057674N1826TPiper PA-28-180 · S/N 28-7105105N182KCCessna TR182 · S/N R18201139N18363Beech E-55 · S/N TE-1105N18394Beech A36 · S/N E-1121N1839RCessna A185F · S/N 18502554N18403Beech A36 · S/N E-1120N185CYCessna A185F · S/N 18502839N18ARBeech 35-C33 · S/N CD-959N190RSBeech 58 · S/N TH-804N1913LBeech F33A · S/N CE-656N1942GCessna 421B · S/N 421B0842N1944GCessna 421B · S/N 421B0844N19UBeech 76 · S/N ME-294
Back to Bas Part Sales LLC