Skip to content

Registered aircraft · 47

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

N10065Johnson Kyle · Exira, IABuilt 1949 · S/N 830 N12087Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 734 N132BRSteinheiser Terry N · Renfrew, PABuilt 1951 · S/N 51-332 N140BL Bachman LLC · Independence, IABuilt 1947 · S/N 60 N153BScotts Helicopter Service · Le Sueur, MNBuilt 1947 · S/N 7 N157BLewis Gerald K · Bakersfield, CABuilt 1947 · S/N 11 N160BJames David R · Wayne, MIBuilt 1947 · S/N 14 N16356Modern American Warrior Inc · Spring, TXBuilt 1951 · S/N 536 N182BLay Lawrence W · Douglass, KSBuilt 1948 · S/N 36 N184BTaz Air Service Inc · Middletown, DEBuilt 1959 · S/N 45 N202CHBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1951 · S/N 301 N225BHammock Flying Service Inc · Smithville, ARBuilt 1949 · S/N 149 N237DJJames David R · Wayne, MIS/N 237 N3103GLancaster Helicopters Inc · Landisville, PABuilt 1959 · S/N 185 N310AAnverse Inc · Cartersville, GABuilt 1947 · S/N 82 N3116GAlvis Michael E · Parkton, NCS/N 284 N347WMLancaster Helicopters Inc · Landisville, PAS/N 61 N4250AIxl Inc · Sulphur, LAS/N 421 N4702SAd-Air And Ag LLC · Dothan, ALS/N B-101R N555ENSetnar Stephen R · Butler, PABuilt 1947 · S/N 6 N63300Bassett Tommy J · Ashford, ALBuilt 1951 · S/N 841 N6579DIxl Inc · Sulphur, LAS/N 895 N7137ZGreenway Michael D · Friday Harbor, WABuilt 1948 · S/N 19 N74004House Guy C · Castle Creek, NYBuilt 1951 · S/N 403 N74005Newton Property Leasing LLC · Greene, IABuilt 1963 · S/N 409 N74081Kehoe Keith J · Marion, TXS/N 216 N74120Slevin Mary Elizebeth · Altamont, NYBuilt 1949 · S/N WH5005 N74124Bowles Alan B · Georgetown, TXBuilt 1963 · S/N WH-5009 N74822Nockair Inc · Longboat Key, FLBuilt 1964 · S/N 456 N74823Tobler Hans P · Anchorage, AKBuilt 1953 · S/N 270 N74898James David R · Wayne, MIS/N AIAT-68 N755ELavanture Richard A · Bristol, INBuilt 1951 · S/N 312 N7802EContinental Helicopters Inc · Mason, TXS/N 473 N78900Master Designs LLC · Gilbert, AZBuilt 1952 · S/N 480 N8117Henry Mark A · Dickinson, TXBuilt 1967 · S/N K732 N8645GTobler Hans P · Anchorage, AKBuilt 1953 · S/N 822 N8975Gauntlett Robert Michael · Yukon, OKS/N 607 N903BCosta James J · Tulare, CABuilt 1954 · S/N 847 N908BPlevyak Malcolm S · Berwick, PABuilt 1952 · S/N 479 N9115ROlson Robert L · Yuba City, CABuilt 1948 · S/N 93 N9158RHaley Lee · Ahwahnee, CABuilt 1960 · S/N 455 N917BQuatacker Matt · Porterville, CABuilt 1952 · S/N 606 N929BValiant Air Command Inc · Titusville, FLS/N 647 N93067Milam Inc · Trussville, ALBuilt 1965 · S/N 5501 N93175Gottschalk Brian D · Moscow, IDS/N 1000 N9421HElliott Miles DBA · Porterville, CABuilt 1950 · S/N 178 N9567CWalker John D · Neosho, MOBuilt 1950 · S/N 212

Back to Bell 47D1