Skip to content

Registered aircraft · 978

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

N14ARRatliff Alvin · Northport, ALBuilt 1975 · S/N CE-561 N1500BElectrical Field Services Inc · Huffman, TXBuilt 1994 · S/N CE-1768 N150DRVan Den Heuvel Michael E · Middleton, WIBuilt 1990 · S/N CE-1473 N1514BLilu LLC · Siloam Springs, ARBuilt 1988 · S/N CE-1276 N1515MSurecraft LLC · Dover, DEBuilt 1988 · S/N CE-1304 N1520GFischer Kurt C · Lyme, CTBuilt 1988 · S/N CE-1283 N1529LSaso Martin P III · Elgin, ILBuilt 1994 · S/N CE-1771 N1535WStark Gary · Riverside, CABuilt 1972 · S/N CE-374 N15454Jb Transportation LLC · Peoria, AZBuilt 1990 · S/N CE-1489 N1545YCenterline Axis LLC · Pagosa Springs, COBuilt 1989 · S/N CE-1313 N1546RJarrell Craig A · Upper Arlington, OHBuilt 1994 · S/N CE-1773 N1546YConway Bruce A · Cape Coral, FLBuilt 1989 · S/N CE-1316 N1550DAlexander Air Consulting LLC · Lees Summit, MOBuilt 1989 · S/N CE-1317 N1550NWilliamson William Robert · Asheboro, NCBuilt 1989 · S/N CE-1323 N1553AN1553a LLC · Belton, TXBuilt 1989 · S/N CE-1315 N15549Hall Patrick D · Lakeway, TXBuilt 1990 · S/N CE1471 N1555WSmith John Albert Jr · Palm Coast, FLBuilt 1988 · S/N CE-1299 N1559LLauritzen Clifton · Chowchilla, CAFirst renewal noticeBuilt 1976 · S/N CE-673 N1561MWagner Lacy F · Mission Viejo, CABuilt 1989 · S/N CE-1374 N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777 N1562BKaplan Steven H Trustee · Santa Barbara, CABuilt 1989 · S/N CE-1362 N1563BShulman David A · Frisco, TXBuilt 1994 · S/N CE-1776 N1563FMcintyre Philip · Monterey, CABuilt 1994 · S/N CE-1782 N1564AMcnutt Seth D · Paoli, INBuilt 1989 · S/N CE-1321 N1566GDuntz David W · Beavercreek, OHBuilt 1989 · S/N CE-1346 N1566PBeech Powers LLC · Henderson, NVBuilt 1988 · S/N CE-1294 N1567MPlumbo John T · Port Saint Lucie, FLBuilt 1989 · S/N CE-1407 N1567PMy Family Holdings LLC · Greenwood, SCBuilt 1988 · S/N CE-1296 N1569PFlying Bull Aviation LLC · Santee, CABuilt 1988 · S/N CE-1300 N1570TAcr Holdings LLC · Marysville, OHBuilt 1989 · S/N CE-1365 N157RDedoming Russell C IV · Boylston, MABuilt 1991 · S/N CE-1636 N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381 N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383 N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637 N1597LTougas John D · Huntingtown, MDS/N CE-638 N159GMArmy Air Corps LLC · Wilmington, DEBuilt 1978 · S/N CE-765 N161TRRambo Timothy B · Nampa, IDBuilt 1991 · S/N CE-1619 N1624WHill Travis · Smithville, TXBuilt 1972 · S/N CE-384 N1643EYoung Michael T · Flower Mound, TXBuilt 1992 · S/N CE1643 N1669WBahri Kiumars · Birmingham, ALBuilt 1972 · S/N CE-392 N166PFroggatt Richard H · Sterling, MABuilt 1991 · S/N CE-1560 N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398 N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419 N16CTOld Boys Aviation LLC · Knoxville, TNS/N CE-843 N170HPKoven Mark Lee · Logan, UTBuilt 1975 · S/N CE-615 N1745WThoroughscape Inc · Wellington, FLBuilt 1972 · S/N CE-409 N17522M & A Business Propertys LLC · Wilmington, DEBuilt 1977 · S/N CE-690 N1753WConservative Three LLC · Taft, CABuilt 1972 · S/N CE-410 N1758WJanneck Curtis · Mooresville, INBuilt 1972 · S/N CE-411 N17607Juren Nicholas J · Los Osos, CABuilt 1977 · S/N CE-695

Back to Beech F33A