Skip to content

Registered aircraft · 34

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 ('1440506')
  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 ('1440506')
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.

N19GLEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N 2004 N2101UVansurdam John R · Seneca, SCBuilt 1961 · S/N 147 N2171UHillberg David · Fountain Valley, CAS/N 333 N2173UInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 335 N2175UOptimus Aircraft Service Inc · Middletown, DEBuilt 1963 · S/N 337 N2179UFlorea Byron · Carencro, LABuilt 1963 · S/N 341 N2191UJohnson Kenneth E · Mahtomedi, MNBuilt 1964 · S/N 402 N2196UZeiner Gary R · Greencastle, INBuilt 1964 · S/N 407 N2236UPrater Jon A · Palm Coast, FLBuilt 1967 · S/N 475 N2238UHewitt Robert E · Bybee, TNBuilt 1968 · S/N 479 N2241ULatimer Mark A · Roanoke, TXBuilt 1968 · S/N 482 N2252USkylake Adventures LLC · Geneva, OHS/N 411 N2257UMurray Richard A · Celina, OHS/N 418 N2259UMyrtle William E · Martinsville, INBuilt 1964 · S/N 421 N2264UJanvrin Jerry M · Buffalo, SDS/N 426 N2270UPrice Keyth E · Ossian, INBuilt 1964 · S/N 433 N2271UHockett James S · Chiloquin, ORBuilt 1964 · S/N 436 N2272USurplus Industrial Materials LLC · Centralia, WAS/N 437 N2277URegistration Pending · Twin Falls, IDRegistration pendingS/N 442 N2284UAttitude Toys LLC · Wilmington, DES/N 454 N2288ULay Jerry K · Minonk, ILBuilt 1966 · S/N 459 N2289UEastern Stearman Inc Trustee · Leesburg, VABuilt 1966 · S/N 460 N2290UVan Surdam John R · Seneca, SCBuilt 1966 · S/N 461 N2291UHines Scott C · Fort Worth, TXBuilt 1966 · S/N 462 N342MLOrlowski Michael A · Gold Hill, NCS/N 343 N383ESDrake Air LLC · Shelbyville, INS/N 344 N400CXCoker Steve L III · Tyler, TXBuilt 1967 · S/N 470 N45448Sorg Dorothy · Elizabethton, TNBuilt 1997 · S/N 2003 N64ZXOros John L · Port Charlotte, FLS/N 404 N7WEBegley Edward R · Glasgow, KYBuilt 1964 · S/N 432 N888CFJph Aviation LLC · Pittsburgh, PABuilt 1965 · S/N 457 N9011RFraundorfer Steven M · Edgerton, WIS/N 2013 N9023MBrandis Robert J · Taylorville, ILS/N 2020 N9061USurplus Industrial Materials LLC · Kalama, WAS/N 2027

Back to Brantly B-2B