Skip to content

Registered aircraft · 270

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

N107WFWilcox Farms Inc · Roy, WABuilt 1961 · S/N 18253149 N109YBraun Joshua S · Port Hope, MIBuilt 1962 · S/N 18253513 N113CMHuling Clinton D · Dutch Harbor, AKBuilt 1960 · S/N 18253043 N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252 N1800QNiswander Richard A · Upton, KYBuilt 1961 · S/N 18253196 N182KPWaddell George M · Hammond, LABuilt 1961 · S/N 18253296 N182PSSso Aviation LLC · Gainesville, FLBuilt 1961 · S/N 18253524 N18TKMcpherson Kathrynne Alexine Trustee · Twin Falls, IDBuilt 1961 · S/N 18253360 N1BPPatton Ministries · Grand Rapids, MNBuilt 1961 · S/N 18253260 N2180SRawson Rodney L · Ellenton, FLBuilt 1961 · S/N 18253525 N21ADBogart Donald W Jr · Long Beach, CABuilt 1961 · S/N 18253313 N22CFGame Equipment Services LLC · Midland, TXBuilt 1961 · S/N 18253217 N2323GLeone Daniel M · Pueblo, COBuilt 1958 · S/N 51623 N261GVBohn Jim A · Mead, WAS/N 18253174 N314TTSappa Valley Construction LLC · Oberlin, KSBuilt 1961 · S/N 18253457 N356JTHorizon Aviation LLC · Mobile, ALBuilt 1960 · S/N 18253096 N359DBKiehne Gary L · Springerville, AZBuilt 1960 · S/N 18253026 N4444WKoehler Robert E · West Lafayette, INBuilt 1961 · S/N 18253371 N504SDPate Charles C Trustee · Wichita, KSBuilt 1961 · S/N 18253203 N54WCFlorian Nathan A · Homosassa, FLBuilt 1961 · S/N 18253465 N600BFarley Bobby Joe · Lawton, OKBuilt 1960 · S/N 18253034 N68639Bathalter Michelle N · Las Vegas, NVBuilt 1960 · S/N 18253073 N6NXGold James M · Kerrville, TXBuilt 1961 · S/N 18253173 N807XMrair LLC · Lewes, DEBuilt 1961 · S/N 18253207 N85TBurbanks Travis · Woodland Hills, CABuilt 1960 · S/N 18253094 N8700XOdonnell Daniel V · Dover, DEBuilt 1960 · S/N 18253100 N8701XThree Green Enterprises LLC · Redondo Beach, CABuilt 1960 · S/N 18253101 N8703XFlying LLC · Kennewick, WAS/N 18253103 N8704XJohnson Hill A · Euless, TXBuilt 1960 · S/N 18253104 N8707XTevis David J · Colorado Springs, COBuilt 1960 · S/N 18253107 N8708XSkylane Flyers LLC · West Jordan, UTBuilt 1960 · S/N 18253108 N8709XWalton T Michael · Hudson Falls, NYBuilt 1961 · S/N 18253109 N8710XDiego Nicholas · Petaluma, CABuilt 1960 · S/N 18253110 N8711XAbidance Inc · Winthrop, WAS/N 18253111 N8713XLentz Walter E · Duncan, OKBuilt 1961 · S/N 18253113 N8714XFrancis Rocky D · Greeley, COBuilt 1960 · S/N 18253114 N8716XKempf Jerry J · Whitefish, MTS/N 18253116 N8717XStevens Matthew S · Penn Yan, NYBuilt 1960 · S/N 18253117 N8720XSparks Brian Elslie · Monmouth, ORS/N 18253120 N8727XWallis Aircraft Inc · Clifford Township, PABuilt 1960 · S/N 18253127 N8728XQualls Randy J · Claremore, OKBuilt 1960 · S/N 18253128 N8731XKabat Jules M · Las Vegas, NVBuilt 1960 · S/N 18253131 N8732XHangar 2 Air LLC · Fort Collins, COBuilt 1960 · S/N 18253132 N8733XLaw Offices Of Brent M Ferrel LLC · Albuquerque, NMBuilt 1961 · S/N 18253133 N8736XBoggio Richard E · Bradenville, PABuilt 1961 · S/N 18253136 N8740XUnwrapped LLC · Dover, DES/N 18253140 N8742XGarletts Frank A · Jackson, MSBuilt 1960 · S/N 18253142 N8745XScott William R · Monroe, GABuilt 1961 · S/N 18253145 N8746XBlack Kevin R · Massillon, OHBuilt 1961 · S/N 18253146 N8747XJodoin Michael G · Belton, SCBuilt 1960 · S/N 18253147

Back to Cessna 182D