Skip to content

Registered aircraft · 96

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2075730')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2075730')
ORDER BY 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.

N53520Harben Grover S III · Gainesville, GAS/N 33701678 N53525Dewind Helicopter LLC · Zeeland, MIBuilt 1976 · S/N 33701682 N53531Hayes Inc · Betsy Layne, KYBuilt 1976 · S/N 33701686 N53555Jewell Aviation Inc · Kennett, MOBuilt 1976 · S/N 33701698 N53573Grand Pre Gary G · Crete, ILBuilt 1976 · S/N 33701711 N53591Turtles Fly Too Inc · Boise, IDBuilt 1976 · S/N 33701727 N53617Holloway Walter F · Cocoa, FLBuilt 1976 · S/N 33701740 N53620Micren Design LLC · Yorktown, VAS/N 33701741 N53628Jacks Charles H · Anguilla, MSBuilt 1976 · S/N 33701743 N53670E&S Management LLC · Miami, FLBuilt 1976 · S/N 33701769 N53671Kennedy David C · San Diego, CABuilt 1976 · S/N 33701770 N53676N5860a LLC · Catawba, NCS/N 33701775 N53687Gessel Todd W · Phoenix, AZBuilt 1977 · S/N 33701784 N53688Moll Jeffery A · Hubertus, WIBuilt 1977 · S/N 33701785 N53704Renforth Michael · Yorktown, VABuilt 1977 · S/N 33701795 N53708Registered aircraftBuilt 1977 · S/N 33701799 N53710High Paint Aviation LLC · Smyrna, SCBuilt 1977 · S/N 33701800 N545TMSmall Mark A · Laveen, AZS/N 33701789 N5JTTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1972 · S/N 33701468 N5RZBbz Consulting LLC · Cody, WYBuilt 1974 · S/N 33701554 N60YAnthem Commercial Air Services Inc · Saint Augustine, FLBuilt 1976 · S/N 33701735 N663GGNt Miller LLC · Winchester, KYBuilt 1975 · S/N 33701634 N700AMInternational Air Services Inc Trustee · Carson City, NVS/N 33701801 N71908Mielke Martin W · Valley City, OHBuilt 1973 · S/N 33701500 N72113N72113 LLC · Harrah, OKS/N 33701521 N72250Anderson Gilbert Lc · Palm Bay, FLS/N 33701548 N72298Ronald D Mcgill Farms Inc · Klamath Falls, ORS/N 33701556 N72342Ampaire Inc · Long Beach, CABuilt 1973 · S/N 33701567 N72361Innovative Solutions Inc · Edmond, OKBuilt 1973 · S/N 33701568 N72370Vinland Aerodrome Inc · Baldwin City, KSS/N 33701570 N72403Drury Edward D · Little Silver, NJS/N 33701576 N72406Mercer Don G · Hendersonville, TNBuilt 1973 · S/N 33701577 N72432Kaono Jerry C · Carson, CABuilt 1973 · S/N 33701581 N72444Valiair Lc LLC Trustee · Casper, WYS/N 33701586 N72446Minerals 66 LLC · Molt, MTBuilt 1973 · S/N 33701587 N72474Dick Ronald J · Fort Wayne, INBuilt 1974 · S/N 33701597 N726ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701661 N742ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701646 N743ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701647 N74LCommunity And Faith Initiatives · Phoenix, AZBuilt 1977 · S/N 33701814 N75NXAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 33701660 N76HFRgp Aviation LLC · The Villages, FLBuilt 1976 · S/N 33701729 N770CDCunningham Campers & Rvs · Clarksville, INBuilt 1976 · S/N 33701774 N868MTBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 33701561 N888BGOgden Thomas C · New Cumberland, WVBuilt 1973 · S/N 33701508 N9LJBurgauer Aviation LLC · Mount Calm, TXS/N 33701777

Back to Cessna 337G