Skip to content

Registered aircraft · 1,111

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

N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516 N90763Apex Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 17275856 N907AZN907az LLC · Miami, FLBuilt 1980 · S/N 17274436 N914AZN969az LLC · Miami, FLBuilt 1985 · S/N 17276379 N917FAAlpha Aircraft International LLC · Lake Worth, FLBuilt 1980 · S/N 17274062 N918FAWestways Aviation LLC · El Cajon, CABuilt 1981 · S/N 17274981 N918VAVolatus Aerospace US Corp · Syracuse, NYS/N 17274912 N918VTChannel Islands Aviation Inc · Camarillo, CAS/N 17275241 N924MCJ Airco LLC · Nashville, TNBuilt 1985 · S/N 17276509 N925MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275341 N932AZN932az LLC · Miami, FLBuilt 1986 · S/N 17276586 N9344LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276543 N9345LHaynie Aviation LLC · Alexander City, ALBuilt 1986 · S/N 17276544 N9358LUnited States Air Force · Eglin Afb, FLBuilt 1986 · S/N 17276546 N9385LFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1986 · S/N 17276548 N9389LL A M Capital Management LLC · Sheridan, WYBuilt 1986 · S/N 17276549 N9400LMerino Cesar · Washington, DCBuilt 1986 · S/N 17276550 N9408LMccallum David DBA · Napa, CABuilt 1986 · S/N 17276551 N9409LLaguna Verde Leasing Inc · Wilmington, DEBuilt 1986 · S/N 17276552 N940AMOracle Aviation LLC · Omaha, NEBuilt 1981 · S/N 17275286 N9411LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276553 N9417LJalomc LLC · Glassport, PABuilt 1986 · S/N 17276555 N941TWHodge Flight Services LLC · Pittsburg, CABuilt 1981 · S/N 17275446 N942AZAz2025 LLC · Miami, FLS/N 17276530 N9433LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276556 N9443LTdz Aircraft Holdings LLC · Dover, DES/N 17276558 N9447LAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1986 · S/N 17276559 N945SMFive Rivers Flight Training LLC · Livermore, CABuilt 1981 · S/N 17274742 N946SMEntrekin David C · Ridgeland, MSBuilt 1982 · S/N 17275870 N9477LSlipstream Aviation LLC · Carrollton, GABuilt 1986 · S/N 17276562 N94ERHill Andrew T · Smithville, TXBuilt 1983 · S/N 17276053 N9507LBatra Sanjeev · Roseville, CABuilt 1986 · S/N 17276566 N950ACRed Carpet Aviation LLC · Carlsbad, CABuilt 1983 · S/N 17276058 N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568 N9522LYellow Jacket Flying Club Inc · Atlanta, GAFirst renewal noticeS/N 17276570 N9537LPence Jeffrey S · Edinburg, VABuilt 1986 · S/N 17276571 N9540LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276574 N9547LCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 17276575 N9566LNorth Sound Aviation · Sedro Woolley, WABuilt 1986 · S/N 17276578 N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580 N9572LJav Air Services LLC · Anchorage, AKBuilt 1986 · S/N 17276582 N96100Trajectory Aviation LLC · Hollywood, FLBuilt 1983 · S/N 17276020 N96105Demon Air LLC · Palm City, FLS/N 17276023 N9616LMid Island Air Service Inc · Ronkonkoma, NYBuilt 1986 · S/N 17276590 N96180Jb Aviation · Bolingbrook, ILBuilt 1983 · S/N 17276034 N96192Hannah Charles B · Skiatook, OKBuilt 1983 · S/N 17276039 N9635LAcme Club Training Inc · Anchorage, AKBuilt 1986 · S/N 17276592 N96493Smtm Holdings Inc · Wilmington, DES/N 17276080 N96503Miravete Paul Trustee · Saint George, UTBuilt 1983 · S/N 17276081 N96567Gmt Aviation LLC · Newtown, CTBuilt 1984 · S/N 17276086

Back to Cessna 172P