Skip to content

Registered aircraft · 230

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

N1009EAven Michael D · Georgetown, INBuilt 1977 · S/N 606-77 N1051EHartman William · Imperial, MOBuilt 1977 · S/N 608-77 N1077EGoebel William R · Rhome, TXBuilt 1977 · S/N 609-77 N1098EKruse Robert M · Liberty, MOBuilt 1977 · S/N 610-77 N10HNMcaleer John J · Bermuda Dunes, CABuilt 1973 · S/N 409-74 N11643Henderson George L · Fresno, CABuilt 1975 · S/N 549-75 N11646Hough Howard A · Paris, TNBuilt 1972 · S/N 311-72 N11659Villa Holdings LLC · Commerce, CABuilt 1972 · S/N 304-72 N11660Gottschalk Brian D · Moscow, IDS/N 305-72 N11677Irby Darrell · Keller, TXBuilt 1972 · S/N 306-72 N11679King Nathan A · Dunkirk, MDBuilt 1972 · S/N 307-72 N11681Amelia Reid Aviation LLC · San Jose, CABuilt 1972 · S/N 308-72 N11684Pepper Richard V · Henderson, TXBuilt 1972 · S/N 309-72 N11686Hopewell Jeffrey D · Temple, TXS/N 310-72 N11687Young William A · Delta Junction, AKBuilt 1972 · S/N 313-72 N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73 N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72 N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72 N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72 N11868Cornelius Joel D · Thief River Falls, MNBuilt 1972 · S/N 301-72 N12206Hth LLC · Merigold, MSBuilt 1972 · S/N 299-72 N12208Shepard John A · Thornville, OHBuilt 1972 · S/N 300-72 N13YCBuckin 307 Taildraggers LLC · Casper, WYBuilt 1976 · S/N 590-76 N142TSAmberly Holdings LLC · Fleming Island, FLS/N 486-74 N1516XNorthern James E · Oakdale, CABuilt 1973 · S/N 379-73 N154WKObx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 451-74 N168JMMarshall John A · Pacific, MOBuilt 1974 · S/N 457-74 N16TPWorsham Farms Flying Service Inc · Camilla, GABuilt 1972 · S/N 302-72 N16VUVipers United LLC · Stoughton, WIBuilt 1974 · S/N 438-74 N1701HAmelia Reid Aviation LLC · San Jose, CABuilt 1974 · S/N 454-74 N18ENOdonnell Daniel V · Dover, DEBuilt 1974 · S/N 477-74 N192BAHarkrader Aviation LLC · Louisa, VABuilt 1974 · S/N 459-74 N19AWFildes Robert D · Saint Charles, MOS/N 425-74 N211WBBargatze Robert F · Three Forks, MTBuilt 1974 · S/N 491-75 N2143CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 423-74 N222RKMiller Bruce · Plano, TXBuilt 1974 · S/N 448-74 N223GLKushner Herbert A · Bridgewater, NJBuilt 1973 · S/N 337-73 N22BCSky Shark Aviation LLC · Brandon, MSBuilt 1975 · S/N 535-75 N22KAHolder Jeffrey J · Madison, GABuilt 1974 · S/N 468-74 N23LNJw Air LLC · Suffolk, VABuilt 1975 · S/N 550-75 N24TJNeilson Keith B · East Lyme, CTBuilt 1976 · S/N 579-76 N2503ZAviation Financial Corp · Torrance, CABuilt 1977 · S/N 613-77 N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77 N2518ZAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 616-77 N28GMooneyham Mark · Auburn, CABuilt 1974 · S/N 434-74 N31256Mason Crosby H · Zebulon, NCBuilt 1972 · S/N 330-72 N31283Somes Jason · Santa Rosa Valley, CAS/N 334-72 N31294Molyneux Gawen G · Yucaipa, CABuilt 1972 · S/N 336-73 N323PRSport Flying USA Services LLC · Lititz, PABuilt 1973 · S/N 381-73 N32BKRagen Caroline Farms LLC · Jonesboro, ARBuilt 1973 · S/N 412-74

Back to Bellanca 7KCAB