Registered aircraft · 26

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

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' OR list_contains(g.other_registrant_names, 'QUALITAIR LLC') ORDER BY g.n_number

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' OR list_contains(g.other_registrant_names, 'QUALITAIR 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 = 'QUALITAIR LLC' OR list_contains(g.other_registrant_names, 'QUALITAIR 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.

N105ATBell Helicopter Textron Canada 206B · S/N 4601Built 2006 · Michelstadt N110TLLeach Ted S1-T · S/N 102986Michelstadt N1308LColumbia Aircraft Mfg LC41-550FG · S/N 41590Built 2006 · Michelstadt N1331HAeronca 15AC · S/N 15AC371Built 1949 · Michelstadt N151WFAgusta A109C · S/N 7628Built 1990 · Michelstadt N181BDBeech B-60 · S/N P-563Michelstadt N206LMCessna U206G · S/N U20603759Built 1977 · Michelstadt N2134CCessna 195 · S/N 16119Built 1955 · Michelstatdt N22BEEckstein Robert W CHRISTEN EAGLE II · S/N ECKSTEIN-0001Built 1982 · Michelstadt N3737Piper PA-46-310P · S/N 468508060Built 1985 · Michelstadt N3784YCessna 210D · S/N 21058284Michelstadt N4104NCessna 140 · S/N 13562Built 1947 · Michelstadt N422DRCirrus Design SR22 · S/N 2705Built 2007 · Michelstadt N425RKRobinson Helicopter R44 II · S/N 14224Built 2018 · Michelstadt N4333Lake LA-4-200 · S/N 565Built 1972 · Michelstadt N555PLPiper PA-46-310P · S/N 4608121Built 1988 · Michelstadt N5633SBeech V35 · S/N D-8330Built 1966 · Michelstadt N5727NCessna A185F · S/N 18503320Built 1977 · Micheistadt N6012BCirrus Design SR22 · S/N 0598Built 2003 · Michelstadt N6106SCommander 114-B · S/N 14626Michelstadt N65020Boeing B75N1 · S/N 75-1204Built 1941 · Michelstadt N681BADiamond Aircraft Ind DA 40 · S/N 40.976Michelstadt N89320Cessna 140 · S/N 8348Michelstadt N927Jones Rod BUSHBY MUSTANG MM1 · S/N 487Michelstadt N9566BCessna 172RG · S/N 172RG0885Built 1981 · Michelstadt N9996Piper PA-34-200T · S/N 347770163Built 1977 · Michelstadt

Back to Qualitair LLC