Registered aircraft · 19

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

N115PWMikoyan Gurevich SB LIM-2 · S/N 512036Built 1955 · Addison, TX N1207Boeing A75 · S/N 75207Built 1940 · Addison, TX N121MGMikoyan Gurevich MIG 21 · S/N 433372128Built 1978 · Addison, TX N1258Osborne James L OSBORNE FOKKER D-VII · S/N 1Built 1990 · Addison, TX N215JCCavanaugh James A JR PITTS S-1S · S/N 21546Built 1984 · Addison, TX N228TSNorth American NA-200 · S/N 200-422Built 1954 · Addison, TX N24935Piper J3C-65 · S/N 3536Built 1939 · Addison, TX N287Consolidated-Vultee 28-5ACF · S/N 48287Built 1943 · Addison, TX N39606Douglas SKYRAIDER AD-6 · S/N 139606Built 1955 · Addison, TX N46217Ryan Aeronautical ST3KR · S/N 1363Built 1941 · Addison, TX N51JCNorth American/Aero Classics P-51D · S/N 44-72339Built 1944 · Addison, TX N5548NNorth American B-25H · S/N 43-4106Built 1943 · Addison, TX N65164Douglas EA-1E · S/N 55-471DHBuilt 1955 · Addison, TX N724RCCavanaugh James A CHRISTEN EAGLE · S/N 002Built 1997 · Addison, TX N7705CDouglas B-26 · S/N 44-35710Built 1944 · Addison, TX N812SBBell UH-1H · S/N 64-13553Built 1964 · Addison, TX N828JCNorth American T-28B · S/N 140012Built 1955 · Addison, TX N86280Grumman TBM-3E · S/N 86280Addison, TX N906HFBeech 65-A90-1 · S/N LM-140Built 1971 · Addison, TX

Back to Cavanaugh Air LLC