Skip to content

Registered aircraft · 420

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

N1632GValentine Robert D · Winfield, KSBuilt 1968 · S/N 627 N1633GCarbiener Ross · Kewanee, ILBuilt 1968 · S/N 628 N1634GBruce Robert W · Frontenac, MNBuilt 1968 · S/N 629 N1659GMills Kurt E · Oak View, CABuilt 1968 · S/N 632 N1660GHintzman Bonnie L · New York Mills, MNBuilt 1968 · S/N 633 N1661GLockbaum James G · Oconomowoc, WIBuilt 1968 · S/N 636 N1664GTownsend Virgil P · Yukon, OKBuilt 1968 · S/N 645 N1667GEngel Craig D · Amboy, INBuilt 1968 · S/N 640 N1668GNewport Signal Air Inc · Anacortes, WAS/N 641 N1669GTaylor Michael P · East Olympia, WAS/N 642 N166DBStokes Lowell W · Kingwood, TXBuilt 1967 · S/N 276 N1672GGivens Benjamin T · Ruffin, SCBuilt 1968 · S/N 643 N1673GLake Robert F · Mechanicsville, MDBuilt 1968 · S/N 644 N1697GConnell Edward A · Crescent City, FLBuilt 1968 · S/N 581 N1699GBeckham Samuel G · Saint Charles, MOBuilt 1968 · S/N 647 N1803GCarolina Aero Group LLC · Youngsville, NCBuilt 1968 · S/N 544 N1805GWilliams Roger A · Langford, SDBuilt 1968 · S/N 559 N1806GAmelia Reid Aviation LLC · San Jose, CABuilt 1968 · S/N 573 N1807GCj Mosman & Son · Nezperce, IDS/N 565 N1808GFleming Tod E · Davenport, WABuilt 1968 · S/N 570 N1809GBerardi Christopher · Crowley, TXBuilt 1968 · S/N 571 N1811GYelle Flyers LLC · Cashion, OKBuilt 1968 · S/N 584 N1813GSenior Flyers LLC · Kalamazoo, MIBuilt 1968 · S/N 596 N1817GJacelon Charles E · Little River, SCBuilt 1968 · S/N 409 N1818GPine Wind Aviation LLC · San Francisco, CABuilt 1968 · S/N 561 N1827GSpangler Anthony J · Bethel, AKBuilt 1968 · S/N 587 N1831GGee3 LLC · Sardis, MSBuilt 1968 · S/N 600 N1836GJensen Steven M · Tioga, NDBuilt 1968 · S/N 595 N1842GOwen Dean W · Morehead, KYBuilt 1968 · S/N 585 N1862GEdwards Keith C · Gloversville, NYBuilt 1968 · S/N 649 N1866GNicollet Flying Club Inc · Nicollet, MNBuilt 1968 · S/N 445 N1872GMcninch Floyd S · Greenville, MES/N 614 N1892GSveen Jeffrey S · Edinburg, NDS/N 612 N1893GDuston James D · Columbus, MSBuilt 1968 · S/N 619 N1894GWeyhe Joel J · Medford, ORBuilt 1968 · S/N 610 N1895GPost Morgan C · Council Bluffs, IABuilt 1968 · S/N 617 N1960PChaffee Harry · Meridian, CAS/N 7ECA-83 N1967TSloan Jeffrey Sterling · Hazen, ARBuilt 1967 · S/N 543 N198JTRibeiro Brian C · Clovis, CABuilt 1995 · S/N 1357-95 N1ZZAnderson Jacob D · Algona, IABuilt 1966 · S/N 347 N202JJCraig Guy R · New Castle, INS/N 161 N2185JSt Clair Donald Lee Jr · Orangevale, CAS/N 215 N220MLSaegaert Daniel G · Locust Grove, GABuilt 1968 · S/N 7ECA-651 N236JTRecord John · Apison, TNBuilt 1970 · S/N 786-71 N2459QBerg Gabriel · Port Angeles, WABuilt 1969 · S/N 711 N2501FAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 7ECA140 N2502FDexter Fred H · Live Oak, FLS/N 152 N2503FSuperior Food Distributors LLC · Naples, FLBuilt 1965 · S/N 153 N2505FAcme Anvil LLC · Parker, COBuilt 1965 · S/N 127 N2507FMorley Thomas O · Emmett, IDS/N 122

Back to Champion 7ECA