Skip to content

Registered aircraft · 1,177

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

N2243CBelleville Livestock Market Inc · Belleville, PABuilt 1953 · S/N 30543 N2244CSkywagon Aero LLC · Wilmington, DES/N 30544 N2245CChesnut Lonnie R · Palmer, AKS/N 30545 N2249CHepburn Joseph · Towanda, KSBuilt 1953 · S/N 30549 N224HThompson Dennis P · Spokane Valley, WABuilt 1956 · S/N 32649 N2252CMickey Donald J · Albuquerque, NMBuilt 1953 · S/N 30552 N2253CFoss David K · Anchorage, AKS/N 30553 N2254CCook Charles Nicholas · Lakeside, TXBuilt 1953 · S/N 30554 N2256CCnd Aerospace Ltd · Telluride, COBuilt 1953 · S/N 30556 N2261CGandy John W III · Mt Vernon, TXBuilt 1953 · S/N 30561 N2263CWalker William S · Shallotte, NCBuilt 1953 · S/N 30563 N2273CCollins John J · Manitowoc, WIBuilt 1953 · S/N 30573 N2284CS L G Enterprises · Shelby Township, MIBuilt 1953 · S/N 30584 N2285CIturriria John M · Kuna, IDBuilt 1953 · S/N 30585 N2292CKlein John T · Austin, ARBuilt 1953 · S/N 30592 N2294CHitch Dixon S · Malta, MTBuilt 1953 · S/N 30594 N2299TC And L Outfitters LLC · Everglades City, FLBuilt 1956 · S/N 32520 N22GCSkydive Ky LLC · Cecilia, KYBuilt 1953 · S/N 30532 N2300CWasp Air LLC · Hamilton, MTBuilt 1953 · S/N 30600 N2304CTumbleson Shelly L · San Antonio, TXBuilt 1953 · S/N 30604 N2305CLatham Cory D · Great Bend, KSS/N 30605 N2311CB & B Aviation LLC · Wayzata, MNBuilt 1953 · S/N 30611 N2315CRegistered aircraftBuilt 1953 · S/N 30615 N2316CTwo Wings LLC · Anchorage, AKBuilt 1953 · S/N 30616 N2318CWebster Robert C · East Jordan, MIBuilt 1953 · S/N 30618 N2322CTwin Otter Internatinal Ltd · Las Vegas, NVBuilt 1953 · S/N 30622 N2323COrvin Sanden Inc · Wyndmere, NDBuilt 1953 · S/N 30623 N2332CBalgoyen James T · Charlotte, MIBuilt 1954 · S/N 30632 N2339CSullivan Nathan · Croton, OHS/N 30639 N2341CBear Trap Enterprises Inc · Caldwell, IDBuilt 1953 · S/N 30641 N2342CHite Donald L · Mc Kinney, TXBuilt 1953 · S/N 30642 N2343CStedman Bernard Warren · Anchorage, AKS/N 30643 N2349CSchwend Brian · Forsyth, MTBuilt 1953 · S/N 30649 N234FNelson Graig M · Eastsound, WABuilt 1955 · S/N 32142 N2350CKeating John C · Prosper, TXBuilt 1953 · S/N 30650 N2351CClemens Aviation LLC · Wichita, KSBuilt 1953 · S/N 30651 N2352CMcmahan Johana · Gakona, AKBuilt 1953 · S/N 30652 N2353COverly Terrence Lee · Tok, AKBuilt 1953 · S/N 30653 N2354CMoma Donald R · Wasilla, AKBuilt 1953 · S/N 30654 N2355CFerguson Edward P · Fargo, NDBuilt 1953 · S/N 30655 N2360CCkt Aviation LLC · Anchorage, AKBuilt 1953 · S/N 30660 N2364CMeinershagen Charles I · Redding, CABuilt 1953 · S/N 30664 N2366CKase Gayle L · Wasilla, AKBuilt 1953 · S/N 30666 N2369CBlackert Charles M · Delaware Water Gap, PABuilt 1954 · S/N 30669 N2371CMathers John R · Denton, TXBuilt 1953 · S/N 30671 N2378CHovda H O · Progreso, TXBuilt 1953 · S/N 30678 N2381CLee Kevin M · Rexburg, IDBuilt 1954 · S/N 30681 N2387CEvans Randall B Trustee · Fallon, NVBuilt 1954 · S/N 30687 N2388CRicottilli Stanley L · Mill Creek, WVBuilt 1953 · S/N 30688 N2392CRoot Eric J · Lakewood, COBuilt 1954 · S/N 30692

Back to Cessna 180