Registered aircraft · 23

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 = '3G CLASSIC AVIATION INC' OR list_contains(g.other_registrant_names, '3G CLASSIC AVIATION INC') 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 = '3G CLASSIC AVIATION INC' OR list_contains(g.other_registrant_names, '3G CLASSIC AVIATION INC')
  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 = '3G CLASSIC AVIATION INC' OR list_contains(g.other_registrant_names, '3G CLASSIC AVIATION INC')
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.

N207RMBoeing A75 · S/N 75294Built 1940 · Wilmington, DE N22416Howard DGA-15P · S/N 515Built 1954 · Wilmington, DE N230CVNorth American F-51D · S/N 44-63788Wilmington, DE N282SWPiper PA46-500TP · S/N 4697420Built 2009 · Wilmington, DE N31068Piper J3C-65 · S/N 5291Built 1940 · Wilmington, DE N345GGGrumman G-21A · S/N B101Wilmington, DE N4151DNorth American P-51D · S/N 44-73458AWilmington, DE N5159VBoeing A75N1 · S/N 752243Built 1941 · Wilmington, DE N52206Boeing A75N1(PT17) · S/N 75-2275Built 1942 · Wilmington, DE N5314NBoeing E75 · S/N 75-5571Wilmington, DE N5315NBoeing E75 · S/N 75-5683Built 1942 · Wilmington, DE N5323NBoeing E75 · S/N 75-5809Built 1942 · Wilmington, DE N57271Boeing A75N1(PT17) · S/N 75-807Built 1940 · Wilmington, DE N59GDRyan Aeronautical ST3KR · S/N 2186Built 1942 · Wilmington, DE N68443Boeing E75 · S/N 75-5611Wilmington, DE N68831Boeing PT-13D · S/N 75-5657Built 1942 · Wilmington, DE N7585Boeing A75 · S/N 75085Wilmington, DE N79535Boeing 75 · S/N 75-6590Built 1942 · Wilmington, DE N869APilatus P3-05 · S/N 507-56Wilmington, DE N9082HBoeing A75 · S/N 75-8564Built 1943 · Wilmington, DE N9478HBoeing B75N1 · S/N 75-6833Built 1943 · Wilmington, DE N9889ZBeech C-45H · S/N AF-805Wilmington, DE N99PFAerotek PITTS SPECIAL S-1S · S/N 1-0006Wilmington, DE

Back to 3g Classic Aviation Inc