Skip to content

Registered aircraft · 53

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

N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212 N190P98 Mike LLC · Hayden, IDBuilt 1964 · S/N P206-0012 N206CGSmalley Glen E · Kasilof, AKS/N P206-0136 N206JFReichert Kenneth J · Deer River, MNBuilt 1965 · S/N P206-0137 N206SDCampbell William P · Matador, TXBuilt 1964 · S/N P206-0053 N206SPHayden Scott · Anchorage, AKBuilt 1965 · S/N P206-0111 N207JUnwrapped LLC · Dover, DEBuilt 1965 · S/N P206-0086 N2504XInspire Technologies Inc · Caldwell, IDBuilt 1964 · S/N P206-0004 N2505XGaviaire Aviation LLC · El Reno, OKBuilt 1965 · S/N P206-0005 N2506XBaumberger Gene C · Greenville, ILBuilt 1965 · S/N P206-0006 N2508XCaspaar Valentin · Seattle, WABuilt 1965 · S/N P206-0008 N2513XChristenson Cole R · West Fargo, NDBuilt 1964 · S/N P206-0013 N2514XAdair Larry K Trustee · Cameron Park, CABuilt 1964 · S/N P206-0014 N2522XAce Handyman Services LLC · Sussex, NJS/N P206-0022 N2526XBolin David A · Kenmore, WAS/N P206-0026 N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028 N2532XTwo River Airspray LLC · Hallock, MNBuilt 1964 · S/N P206-0032 N2536XLouscher Steven Trustee · Paullina, IABuilt 1964 · S/N P206-0036 N2541XEco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N P2060041 N2547XOber John A · Candor, NYS/N P206-0047 N2551XMcgrath Paul · Potsdam, NYBuilt 1965 · S/N P206-0051 N2552XN2552x LLC · Boulder, COBuilt 1964 · S/N P206-0052 N2554XWallin Justin · Henderson, NVBuilt 1964 · S/N P206-0054 N2556XHusnik Brad M · Forest Lake, MNBuilt 1964 · S/N P206-0056 N2557XRegistration Pending · Troy, IDRegistration pendingBuilt 1964 · S/N P206-0057 N2559XElement Building Solutions Inc · Murphys, CABuilt 1965 · S/N P2060059 N2560XCd Hillcroft Aviation LLC · Superior, COBuilt 1965 · S/N P206-0060 N2561XN343ga Leasing LLC · Anchorage, AKBuilt 1965 · S/N P206-0061 N2568XPeasley Casey · Eagle, IDBuilt 1965 · S/N P206-0068 N2572XC S Enterprises Llp · Morristown, TNBuilt 1965 · S/N P206-0072 N2573XSkd LLC · Spokane, WABuilt 1965 · S/N P206-0073 N2575X360 Solo LLC · San Martin, CABuilt 1965 · S/N P206-0075 N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083 N2592XLorraines Blue Sky Aviation LLC · Norman, OKBuilt 1965 · S/N P206-0092 N2596XCarter Jason J · Athena, ORBuilt 1965 · S/N P206-0096 N2597XCavaness Gary Frank Jr · Anchorage, AKBuilt 1965 · S/N P206-0097 N2598XGilliland James H · Curwensville, PABuilt 1965 · S/N P2060098 N2606XSmith And Cherry Aviation LLC · Knoxville, TNBuilt 1965 · S/N P206-0106 N2608XOdonnell James E · Northport, NYBuilt 1965 · S/N P2060103 N2612XMcnutt Brian K · Dillon, MTBuilt 1965 · S/N P206-0112 N2617X2gl P&I LLC · El Paso, TXBuilt 1965 · S/N P206-0117 N2619XBrume Shawn O · Fairbanks, AKBuilt 1965 · S/N P206-0119 N2624XBritton Daniel W · Fairbanks, AKBuilt 1965 · S/N P206-0124 N2630XBbjc Adventures LLC · Jackson, WIBuilt 1965 · S/N P206-0130 N2649XK-Mcj Equipment LLC · Longview, TXS/N P206-0149 N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162 N2825XJames Ray Inc · Twin Falls, IDS/N P206-0025 N442SSN442ss LLC · Middletown, OHBuilt 1965 · S/N P206-0121 N527BMMarc Inc · Bolton, MSS/N P2060035 N65206Brinkhoff Gary H · Hygiene, COBuilt 1964 · S/N P206-0024

Back to Cessna P206