Skip to content

Registered aircraft · 1,636

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

N229DKKoerkenmeier James J · Carlyle, ILBuilt 1979 · S/N 15283544 N230SVSwailes Craig · Taylor, MIBuilt 1979 · S/N 152-83257 N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714 N240SUOhio State University · Columbus, OHBuilt 1981 · S/N 15285153 N24214Mckinney Brett A · Hackleburg, ALBuilt 1977 · S/N 15280154 N24242Fly Sky Ads LLC · Manalapan, NJBuilt 1977 · S/N 15280170 N24260Aerial Banners Inc · Pembroke Pines, FLBuilt 1977 · S/N 15280180 N24261Citabria Inc · Auburn, CABuilt 1977 · S/N 15280181 N24264Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280183 N24266Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280185 N24269Sioux Air Inc · South Sioux City, NEBuilt 1977 · S/N 15280186 N24296Cc Aviation Inc · Tracy, CABuilt 1977 · S/N 15280201 N24305Woolsey Joseph A · Squaw Valley, CABuilt 1977 · S/N 15280206 N24313Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280210 N24315Cubicle Concepts Inc · New Holland, PABuilt 1977 · S/N 15280212 N24327Centurion Aviation · Salina, KSFirst renewal noticeBuilt 1977 · S/N 15280218 N24331Registration Pending · Norman, OKRegistration pendingBuilt 1977 · S/N 15280219 N24333Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280220 N24351426th Aero Squadron LLC · Cropwell, ALBuilt 1977 · S/N 15280230 N24363Sale Reported · Crystal, MNSale reported, canceledBuilt 1977 · S/N 15280235 N24364Monsalve Carlos M · Lewiston, NYBuilt 1977 · S/N 15280236 N24373Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280240 N24385Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1977 · S/N 15280248 N24399Lcc North LLC · Freehold, NJBuilt 1977 · S/N 15280252 N244004 One Air LLC · Holland, MIBuilt 1977 · S/N 15280253 N24403Somboonsap Patanapong · Oakland Park, FLBuilt 1977 · S/N 15280254 N24472Payne Richard L · Flint Hill, VABuilt 1977 · S/N 15280272 N24486Wilson Seth · Shafter, CABuilt 1977 · S/N 15280283 N24498Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280290 N24501Dsr Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 15280292 N24512Moran Erick A · Orange, CABuilt 1977 · S/N 15280300 N24522Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280309 N24530Mayfield Jon David · Dublin, TXBuilt 1977 · S/N 15280313 N24532Christiansen Aviation LLC · Wilmington, DEBuilt 1977 · S/N 15280315 N24544Comer Dwayne M · Glendale, AZS/N 15280323 N24546Valestin Donald P · Queen Creek, AZBuilt 1977 · S/N 15280325 N24553Jensen Aviation LLC · Rancho Cucamonga, CABuilt 1977 · S/N 15280328 N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332 N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334 N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341 N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969 N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355 N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361 N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362 N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363 N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364 N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365 N24773Grusy Norman D · Portland, ORS/N 15280369 N24775Cal Aggie Flying Farmers Inc · Davis, CABuilt 1977 · S/N 15280371 N24781Shaw Erin · Reno, NVBuilt 1977 · S/N 15280375

Back to Cessna 152