Skip to content

Registered aircraft · 1,064

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

N3062XReeser Peggy E · Paige, TXBuilt 1966 · S/N 15064462 N3063XN3063x LLC · New Braunfels, TXBuilt 1966 · S/N 15064463 N3064XAldridge James M · Fairbanks, AKBuilt 1966 · S/N 15064464 N3071XSmith Lawrence A · Alleyton, TXBuilt 1966 · S/N 15064471 N3076XOlesen Wayne O · Troy, IDBuilt 1966 · S/N 15064476 N3078XRogers Matthew J · New Paltz, NYBuilt 1966 · S/N 15064478 N3080XN3080x LLC · Greenwood Village, COBuilt 1966 · S/N 15064480 N3089XNostdahl Robert W · Bottineau, NDBuilt 1966 · S/N 15064489 N3090XSills Garry D · Malakoff, TXBuilt 1966 · S/N 15064490 N3091XConnolly Shawn P · Chicopee, MABuilt 1966 · S/N 15064491 N3093XGadler Timothy L · Lake Oswego, ORS/N 15064493 N3097XSmall James M · Carthage, INBuilt 1966 · S/N 15064497 N3098XAnnrich Corp · Mc Lean, NYBuilt 1966 · S/N 15064498 N30LDPartlow David D Jr · Pahoa, HIBuilt 1966 · S/N 15063631 N3101XBlalock Bernnie R · Washington, OKBuilt 1966 · S/N 15064501 N3102XJoshua Aircraft LLC · Georgetown, DEBuilt 1966 · S/N 15064502 N3107XPage Trenton Vaughn · Warner Robins, GABuilt 1966 · S/N 15064507 N3113XAfp Aerospace LLC · West Palm Beach, FLBuilt 1966 · S/N 15064513 N3115XReeve Howard E · Minot, NDS/N 15064515 N3116XRegistered aircraftBuilt 1966 · S/N 15064516 N3118XMoody Dalton T · Evansville, INBuilt 1966 · S/N 15064518 N3123XRegistered aircraftBuilt 1966 · S/N 15064523 N3130XE & D Farms · Marienthal, KSBuilt 1966 · S/N 15064530 N3132XMerrill Gary W · Dallas, TXBuilt 1966 · S/N 15064532 N333MWThird Oak Aviation LLC · Statham, GABuilt 1966 · S/N 15063324 N337XCHoover Rodney A · Wasilla, AKBuilt 1966 · S/N 15062891 N34GMinerva Keith R · Jacksonville, FLS/N 15061615 N3500LDragonfly Aviation LLC · Winder, GABuilt 1965 · S/N 15062300 N3505LPilot Training Northwest LLC · Sandpoint, IDBuilt 1965 · S/N 15062305 N3509LNortheastern Oregon Flying Club · La Grande, ORBuilt 1965 · S/N 15062309 N3520LGregory Austin · Bothell, WABuilt 1965 · S/N 15062320 N3521LBiorn Howard L · Brooklyn Center, MNS/N 15062321 N3522LTyler Clark D · Fort Wayne, INS/N 15062322 N3526LLewis Clinton A · Antlers, OKS/N 15062326 N3527LAiken Clifford M Jr · Loganville, GABuilt 1965 · S/N 15062327 N3528LTioga Land Development LLC · Tioga, NDS/N 15062328 N3531LLihs Austin R · Sioux City, IAS/N 15062331 N3535LToy Donald R · Homestead, IABuilt 1965 · S/N 15062335 N3536LPnw Sky Trekking LLC · Colville, WABuilt 1965 · S/N 15062336 N3539LCummings Kenneth · Camano Island, WABuilt 1965 · S/N 15062339 N3543LPeaster David · Brunswick, GABuilt 1965 · S/N 15062343 N3553LDulce Vida Property Consultants LLC · Denver, NCBuilt 1965 · S/N 15062353 N3556LBurrows Brian A · Argyle, TXS/N 15062356 N3557LStauffer Tom · Renton, WABuilt 1965 · S/N 15062357 N3563LMartinez Guillermo E · Upland, CABuilt 1965 · S/N 15062363 N3573LGlasgow Jason D · Tecumseh, OKBuilt 1965 · S/N 15062373 N3574LMillican Marc J · Anchorage, AKBuilt 1965 · S/N 15062374 N3575LSwann Robert A · Hereford, AZS/N 15062375 N3577LWimpey Robert J · Roundhill, KYBuilt 1965 · S/N 15062377 N3584LKlesser Zachary S · Coronado, CABuilt 1965 · S/N 15062384

Back to Cessna 150F