Skip to content

Registered aircraft · 3,138

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

N3050EDsi Limited Liability Corp · Blue Ridge, VABuilt 1978 · S/N 17271419 N3051EBellingham Aviation Services LLC · Bellingham, WABuilt 1978 · S/N 17271420 N3054EPrinceton Flying Club Inc · Wilmington, DEBuilt 1978 · S/N 17271421 N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425 N3072EReed Michael A Trustee · Minerva, OHBuilt 1978 · S/N 17271428 N3076EHinkes Kenny · Albuquerque, NMBuilt 1978 · S/N 17271430 N3077EBlackhawk Holding Corp · Wilmington, DEBuilt 1978 · S/N 17271431 N307SPSheridan Pilots 307 LLC · Sheridan, WYBuilt 1979 · S/N 17273438 N3080ESky Safety Inc · San Antonio, TXBuilt 1978 · S/N 17271433 N3082EAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1978 · S/N 17271435 N3086EMcclurkin David A · Norman, OKBuilt 1978 · S/N 17271436 N3093EBrown Joseph M · Kansas City, MOBuilt 1978 · S/N 17271440 N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043 N30RHHalye Roger J · Port Orange, FLBuilt 1977 · S/N 17269998 N3107PRonald Waldron · Strongsville, OHBuilt 1979 · S/N 17272223 N310FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272281 N311EHFive Six Zero One LLC · Orange, CABuilt 1977 · S/N 17269158 N311HBChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272347 N3123EKanase Padmaneel B · Amarillo, TXS/N 17271444 N3126EN3126e LLC · Columbus, OHBuilt 1978 · S/N 17271446 N312SMShelbyville Flight Academy LLC · Smyrna, TNBuilt 1977 · S/N 17270091 N312TATaylor Charles E · Glen Ellyn, ILBuilt 1979 · S/N 17273565 N3135EHerring Christopher E · Granbury, TXBuilt 1978 · S/N 17271447 N3137ERegistered aircraftBuilt 1978 · S/N 17271448 N3141EPower City Aviation Inc · Hazleton, PABuilt 1978 · S/N 17271449 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N3151EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271453 N3159EDinaland Aviation · Vernal, UTS/N 17271455 N3165EJlk Management LLC · Kerrville, TXBuilt 1978 · S/N 17271457 N316ACheng Williams W · North Potomac, MDBuilt 1979 · S/N 17273226 N3171EJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271459 N3173ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271461 N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183 N31CNSkyland Aviation LLC · Alpine, CABuilt 1976 · S/N 17267936 N31JBLucian Aviation LLC · Modesto, CAS/N 17273002 N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693 N3200ERegistration Pending · Burlington, WIRegistration pendingBuilt 1978 · S/N 17271466 N3206EMorey Airplane Company Inc · Middleton, WIBuilt 1978 · S/N 17271467 N3207EArmstrong Aviation LLC · New Orleans, LABuilt 1978 · S/N 17271468 N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470 N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475 N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231 N3238ESwiss Jack S · Anchorage, AKBuilt 1978 · S/N 17271477 N3239ELeaf Air LLC · Queensbury, NYBuilt 1978 · S/N 17271478 N3257EFlycarolina LLC · Concord, NCBuilt 1978 · S/N 17271482 N3265ETa Brand LLC · Middletown, DEBuilt 1978 · S/N 17271483 N3266EN3266e LLC · Homestead, FLBuilt 1978 · S/N 17271484 N3273EAnderson Thomas J · Big Bear City, CABuilt 1978 · S/N 17271486

Back to Cessna 172N