Skip to content

Registered aircraft · 46

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

N116TBMcmullan Francis G · Weirsdale, FLS/N 362 N128SAFly-Right Aviation LLC · Anderson, SCS/N 355 N191JStyer David B · Pendleton, ORBuilt 1977 · S/N 390 N212AKHinshaw Martin E · Wasilla, AKBuilt 1978 · S/N 431 N255JSFalcon Helicopters Inc · Logan, NMS/N 364 N35ZEFerree Thomas L · Wampum, PABuilt 1981 · S/N 508-2R N4210Lrh Equipment LLC · Pendleton, ORS/N 421 N51665Rotor-Lift LLC · Swartz Creek, MIS/N 404 N51693Borreson Anthony · Reno, NVBuilt 1977 · S/N 411 N51699Styer David B · Pendleton, ORBuilt 1977 · S/N 416 N51757Spencer John S · Indian, AKBuilt 1978 · S/N 423 N51758Enstrom Instruction LLC · Newark, DEBuilt 1978 · S/N 435 N51768Stocker Concrete Co · Gnadenhutten, OHBuilt 1978 · S/N 446 N51769Arizona Skies Aviation LLC · Scottsdale, AZS/N 443 N51770Lrh Equipment LLC · Pendleton, ORS/N 445 N51774Salaika Timothy A · Danbury, TXS/N 440 N51778Medical Evacuation Disaster Intervention Corps · Springdale, ARS/N 451-2 N51788Rhoads Timothy C · Logan, NMBuilt 1978 · S/N 452-2 N51789Breyer Charles A · Lewes, DEBuilt 1978 · S/N 454-2 N539HSharkey'S Helicopters Inc · West Lebanon, NHBuilt 1976 · S/N 334 N53SABorreson Anthony · Reno, NVBuilt 1977 · S/N 385 N542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343 N544HLrh Equipment LLC · Pendleton, ORS/N 335 N549HBazemore Dennis A · Ingleside, TXBuilt 1976 · S/N 345 N56874Styer David B · Pendleton, ORBuilt 1979 · S/N 467 N5688RLowell Darryl S · Anchorage, AKS/N 466-2 N5688TJoe Koch Construction Inc · Youngstown, OHBuilt 1980 · S/N 480-2 N5689NRobinson Ryan A · Burbank, CABuilt 1979 · S/N 468-2 N5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 477 N5690PMultiaero Corp · Brooklyn, NYS/N 475-2 N5691MBrowning Robert F · Washington, DCBuilt 1980 · S/N 485-2 N5692YSilverado Sales Inc · Orem, UTBuilt 1980 · S/N 494-2 N5694AStyer David B · Pendleton, ORBuilt 1980 · S/N 491-2 N5696MHubbard Benjamin L · Quogue, NYBuilt 1980 · S/N 502-2 N572HCordrey Kenneth R · Delmar, DEBuilt 1976 · S/N 356 N624CECertified Equipment Inspections LLC · Washington, PAS/N 462 N631DPHeritage Rotors LLC · De Leon Springs, FLBuilt 1980 · S/N 492-2 N643HHagglund Caleb J · Pendleton, ORS/N 396 N666MDLrh Equipment LLC · Pendleton, ORS/N 338 N728DBStyer David B · Pendleton, ORBuilt 1993 · S/N 332 N77HXAppold Dave J · Bay City, MIBuilt 1979 · S/N 4702 N80193Fisher Larry L Jr · Saint Charles, MIBuilt 1976 · S/N 366 N86198Styer David B · Pendleton, ORBuilt 1981 · S/N 521-2 N88RWRhoads Timothy C · Logan, NMS/N 518-2 N90BZMirand Alexander A · Huntington Beach, CAS/N 408 N9552Runge Kerry A · Crystal Lake, ILBuilt 1978 · S/N 056

Back to Enstrom F-28C