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

N1000RSterling Foundation · Valparaiso, INS/N 1732 N1001Hokuf Erik L · Bemidji, MNBuilt 1947 · S/N 980 N1068WSterling Foundation · Valparaiso, INBuilt 1956 · S/N 544 N106GGGrubb Gary G · Kingfisher, OKBuilt 1943 · S/N 760 N1101Berry Machine & Tool Co Inc · Camden, TNBuilt 1944 · S/N 1761 N1149VWalker Charles T · Canton, TXBuilt 1943 · S/N 924 N115PMuseum Of Flight Hixson · Hixson, TNBuilt 1944 · S/N 926 N1227Howard Aviation LLC · Marblehead, OHBuilt 1940 · S/N 516 N1311MMiller David L Jr · Moberly, MOS/N 910 N1335MMartin Thomas R · Roseville, MNBuilt 1943 · S/N 29510 N1336MHargreaves William A · Lovettsville, VABuilt 1943 · S/N 1714 N1785HKreutzfeld James E · Marbehead, OHBuilt 1943 · S/N 1785 N22404Leroux Yvette · Scottsdale, AZBuilt 1939 · S/N 500 N22410Vaughan Michael R · Saint Augustine, FLBuilt 1940 · S/N 509 N224163g Classic Aviation Inc · Wilmington, DEBuilt 1954 · S/N 515 N22418Bohl Howard M · Temecula, CABuilt 1940 · S/N 517 N22423American Classic Aero LLC · Kalispell, MTBuilt 1940 · S/N 522 N22424Iverson Kristen L · Lino Lakes, MNBuilt 1940 · S/N 523 N22440Nebulous LLC · Broomfield, COBuilt 1941 · S/N 539 N2464Kreutzfeld Kenneth F · Port Clinton, OHS/N 503 N26JAircraft Marketing & Leasing LLC · Fairbanks, AKS/N 1015 N2737Atchley Joshua K DBA · Sikeston, MOS/N 1020 N28259Lambert James A · Cottage Grove, ORBuilt 1941 · S/N 548 N29457Bowe Walter C Trustee · Sonoma, CABuilt 1943 · S/N 782 N296YLutes Ralph E · Shipshewana, INBuilt 1946 · S/N 1753 N3347GHolcomb Aerial Service · Flora, MSBuilt 1944 · S/N 941 N36259Sterling Foundation · Valparaiso, INBuilt 1944 · S/N 1770 N42429Plane Fun Inc Tr Trustee · Snellville, GABuilt 1940 · S/N 528 N450HDSchwabauer Michael D · Athens, GABuilt 1943 · S/N 731 N4616NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1943 · S/N 709 N4638NWhite Bear Dga LLC · Helena, MTBuilt 1944 · S/N 1011 N4641NPikes Peak Flyers Llp · Colorado Springs, COBuilt 1943 · S/N 705 N4646NGourley Jonathon L · Graham, WABuilt 1943 · S/N 773 N4675NSharp Aviation LLC · Pauls Valley, OKBuilt 1944 · S/N 973 N49791Sterling Foundation · Valparaiso, INS/N 755 N52834Skinner Lawrence W · Fort Myers, FLBuilt 1944 · S/N 1763 N52928Miller David L Jr · Port Orange, FLBuilt 1944 · S/N 1018 N52947Museum Of Flight Foundation · Seattle, WABuilt 1946 · S/N 559 N52986Spence Ronald J · Germantown, TNBuilt 1944 · S/N 988 N52991Podzemny Allison · Bogata, TXS/N 925 N53386Houck Mark J · Fredericksburg, PAS/N 29511 N53HAppleton Tyler C · Evergreen, COS/N 873 N5432NLiptrap Mark G · Spokane, WABuilt 1940 · S/N 519 N5450NGoldstein Michael Frank · Medina, OHBuilt 1944 · S/N 1815 N5524NGourley Jonathon L · Graham, WABuilt 1943 · S/N 890 N55434Larmon Larry V · Valparaiso, INS/N 774 N5553NNighthawk Air Systems Inc · Marion, TXS/N 978 N5604VBole David M · Auburn, WABuilt 1943 · S/N 859 N5605Wings West Consulting LLC · Mesa, AZBuilt 1941 · S/N 547 N58834Bohl Howard M · Temecula, CAS/N 561

Back to Howard DGA-15P