Skip to content

Registered aircraft · 157

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

N2773TPovilaitis Carl A · Glendale, CABuilt 1967 · S/N TE-376 N2778THavrick Jason T · Bridgeport, TXBuilt 1967 · S/N TE-378 N277JMN541mg Inc · Big Pine Key, FLBuilt 1966 · S/N TE-215 N277MDRegistered aircraftBuilt 1966 · S/N TE-223 N2787TBombero Aviation LLC · Childress, TXBuilt 1967 · S/N TE-388 N2791TJoyce George E · Franklinville, NCS/N TE-384 N282JLSieck Joshua · Edmond, OKBuilt 1967 · S/N TE-355 N317BDRegistered aircraftBuilt 1967 · S/N TE-317 N318ALeaders Robert O · Clear Lake, MNBuilt 1966 · S/N TE-229 N318DSchutes John T · Brimfield, MABuilt 1967 · S/N TE-311 N325SRFingerhut Steven · Cross Plains, TXBuilt 1966 · S/N TE-65 N333XJpg Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-266 N3367Klaasmeyer Construction Co · Conway, ARBuilt 1966 · S/N TE-146 N33PCFrisbee Dennis R · Denton, TXBuilt 1966 · S/N TE-77 N340BNewberg Edgar T · Hector, MNBuilt 1967 · S/N TE-333 N355WBWhite River Aviation LLC · Midway, ARBuilt 1966 · S/N TE-287 N3716QHoward Michael I · Shelley, IDBuilt 1967 · S/N TE-297 N3733QChalender Robert C · Cocoa, FLBuilt 1967 · S/N TE-294 N3734QInternational Aviation Industries LLC · Kalispell, MTS/N TE-303 N3738QLumpkin Ed · Rosie, ARS/N TE-305 N3747QWolff Charles L · Pensacola, FLBuilt 1967 · S/N TE-307 N3795QGreen Aviation Inc · Manchester, MEBuilt 1967 · S/N TE-328 N382SHernandez Luis A · Longview, TXBuilt 1966 · S/N TE-166 N39PRAeroplanes LLC · Cary, NCBuilt 1965 · S/N TE-23 N3SUJenkins David G · Grantville, GABuilt 1965 · S/N TE-21 N407TVolunteer Aerials LLC · Stanley, NCBuilt 1966 · S/N TE-231 N409VRegistered aircraftBuilt 1965 · S/N TE-7 N4112Feltmann Dean A · North Charleston, SCBuilt 1966 · S/N TE-159 N412JLBills Brian J · Corry, PABuilt 1966 · S/N TE-38 N416MKSmith Jason · Cresson, TXBuilt 1967 · S/N TE-426 N41QCMark J Heistad · Covington, LAS/N TE-150 N435MCSmoketown Flight Center LLC · Smoketown, PABuilt 1967 · S/N TE-435 N447JLKjolsing Jerome M · Camino, CABuilt 1966 · S/N TE-121 N465PEHoyle Jason R · Grove, OKBuilt 1966 · S/N TE-112 N477JGulf Airbatics Ltd · Jennings, LABuilt 1966 · S/N TE-108 N4867JNational Aero Services LLC · Helena, MTBuilt 1966 · S/N TE-276 N4868JFoster Milton F · Dawson, GABuilt 1966 · S/N TE-277 N4869JDls Aviation LLC · Gilmer, TXBuilt 1966 · S/N TE-281 N494AStotlar William B · Pinckneyville, ILBuilt 1967 · S/N TE-370 N49MDHayes Jack D · Kingman, AZBuilt 1966 · S/N TE-57 N514KCPerazzola Carl J · Bonaire, GABuilt 1966 · S/N TE-82 N520TStanton Thomas M · Mcallen, TXBuilt 1966 · S/N TE-63 N527MLMoss Herman D · Centreville, VABuilt 1966 · S/N TE-217 N52MBRoark Dale L · Cheyenne, OKS/N TE-395 N531UArizona Air Transport LLC · Mesa, AZBuilt 1966 · S/N TE-104 N53QMWings Enterprizes Ltd Co · Yukon, OKBuilt 1967 · S/N TE-312 N5422ULeft Base LLC · Austin, TXBuilt 1967 · S/N TE-407 N5437UBatdorf Richard E · Naples, FLBuilt 1967 · S/N TE-406 N554CLLacy Clay · Groveland, CABuilt 1966 · S/N TE-99 N555PManson Howard William · Pinckney, MIBuilt 1966 · S/N TE-164

Back to Beech 95-C55