Qualitair LLC Trustee
Registered aircraft · 254
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 = 'QUALITAIR LLC TRUSTEE' OR list_contains(g.other_registrant_names, 'QUALITAIR LLC TRUSTEE') 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 = 'QUALITAIR LLC TRUSTEE' OR list_contains(g.other_registrant_names, 'QUALITAIR LLC TRUSTEE') 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.
N100BQScoda Aeronautica Ltda SUPER PETREL XP · S/N S0421N100FRCirrus Design SR22 · S/N 0770N100UUPilatus PC-6/B2-H4 · S/N 1000N100WSBeech F33A · S/N CE-1202N1019VRobinson Helicopter R44 · S/N 1353N101KGBeech B36TC · S/N EA392N102CAAviat A-1B · S/N 2272N110GLMesserschmidt-Bolkow-Blohm GMB BO-105 P1M · S/N 6031N111AAero C-104 · S/N 214N1135KTextron 525 · S/N 525-1135N114DKSocata TB-20 TRINIDAD · S/N 0923N117PRPiper PA-46-600TP · S/N 4698117N118MXCirrus Design SR22T · S/N 0723N11VDSocata TB20 · S/N 2052N11ZDMooney M20M · S/N 270025N11ZTBeech 33 · S/N CE-1108N120GLMesserschmitt Bolkow Blohm GMB BO-105 P1M · S/N 6126N121WHWilliam M Hudgens JA30 SUPERSTOL · S/N JA377-05-14N12336Cessna 172M · S/N 17261936N125BJCessna 525A · S/N 525A0101N133BJBucker Jungmeister BU 133 · S/N 3N133CDCirrus Design SR20 · S/N 1025N138SWCessna 182Q · S/N 18265569N13NEPiper PA 31P 350 · S/N 31P-8414035N13URCirrus Design SR22T · S/N 11039N141EAEclipse EA500 · S/N 000223N150AQKoliber PZL-150A · S/N 04940067N150DDouglas DC3C-S1C3G · S/N 4463N151WNorth American F-51D · S/N 45-11540NN1530XPiper PA-28R-200 · S/N 28R-7535312N153ECirrus Design SR22 · S/N 2415N153EJPiper PA 31P 350 · S/N 31P-8414011N155JCessna 421B · S/N 421B-0246N1567DCessna 195A · S/N 7789N1707Mooney M20J · S/N 24-0263N1721Beech A36AT · S/N E-2783N177DJHumphreys B D/Humphreys J D PITTS SPEC S1S · S/N 002N177HCPiper PA 46-350P · S/N 4636314N1799Ryan Aeronautical ST3KR · S/N 1799N1872QCessna 177RG · S/N 177RG0272N195JRBeech 95 · S/N TD-15N1966BDehavilland DHC-2 · S/N 1615N196SLPiaggio Aero Industries P180 · S/N 1216N202ASPiper PA-28-180 · S/N 287305465N203RVEmmons John RV-3 · S/N 597N203TSDiamond Aircraft Ind DA 40 · S/N 40.973N2121CCirrus Design SF50 · S/N 0756N2130KPiper PA-28RT-201T · S/N 28R-7931023N2199HPiper PA-28RT-201T · S/N 28R-7931005N2200FCessna T182T · S/N T18208732
Back to Qualitair LLC Trustee