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.

N8752XSmith Timothy R · Auburn, CABuilt 1961 · S/N 18253152 N8754XSutton Aircraft Salvage LLC · Palmer, AKBuilt 1960 · S/N 18253154 N8756XGabelli Casey · Ridge Manor, FLBuilt 1961 · S/N 18253156 N8759XGrald Jonathan A · Goshen, NYBuilt 1961 · S/N 18253159 N8763XRegistered aircraftBuilt 1961 · S/N 18253163 N8764XAdventist World Aviation · Wilson, NCBuilt 1961 · S/N 18253164 N8766XFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVBuilt 1960 · S/N 18253166 N8767XSmith Todd A · Duchesne, UTBuilt 1960 · S/N 18253167 N8768XBeachy Phil · Bonners Ferry, IDBuilt 1960 · S/N 18253168 N8769XOmega I Corp Inc · Middletown, DEBuilt 1961 · S/N 18253169 N8770XRegistration Pending · Tulsa, OKRegistration pending, pending cancellationBuilt 1961 · S/N 18253170 N8771XAgainst The Wind Inc · Jasper, TNBuilt 1961 · S/N 18253171 N8775XJust Jump Skydiving LLC · Laurens, NYBuilt 1961 · S/N 18253175 N8779XPannell James R · Carrabelle, FLS/N 18253179 N8781XWinterholler Robert D · Lovell, WYBuilt 1961 · S/N 18253181 N8782XSpo Land And Cattle LLC · Springville, AZS/N 18253182 N8784XHubele James R · Independence, ORBuilt 1961 · S/N 18253184 N8786XCedar Valley Air LLC · Lehi, UTS/N 18253186 N8788XAero Cg LLC · Fresno, CABuilt 1961 · S/N 18253188 N8789XWinfreds Legacy LLC · Oneonta, ALBuilt 1961 · S/N 18253189 N8790XTyler Ronald D Jr · Harlingen, TXBuilt 1961 · S/N 18253190 N8791XJoseph Gary W · Torrance, CABuilt 1961 · S/N 18253191 N8792XN8792x LLC · Loveland, COBuilt 1961 · S/N 18253192 N8793XFowler Kristina M · Georgetown, CABuilt 1961 · S/N 18253193 N8794XSpencer Stacia L · Pomona, KSBuilt 1961 · S/N 18253194 N8800XCox David L · Denton, TXBuilt 1961 · S/N 18253200 N8802XMurphy James L · El Reno, OKBuilt 1961 · S/N 18253202 N8804XDixon Peter J · Carlton, WABuilt 1961 · S/N 18253204 N8809XParker James G Jr · Bellevue, NEBuilt 1961 · S/N 18253209 N8810XLaughlin Robert L · Santa Ynez, CAS/N 18253210 N8811XSchwarzmann Bryce A · Falls Church, VABuilt 1961 · S/N 18253211 N8812XOconnor Brian Edmond · Portland, ORS/N 18253212 N8813XMeccanized LLC · Kalispell, MTBuilt 1960 · S/N 18253213 N8814XCloudstreet Flying Services · Broomfield, COBuilt 1961 · S/N 18253214 N8821TDraper Floyd L · El Paso, TXBuilt 1961 · S/N 18253570 N8822XRambo Barry T · Bradley, SCBuilt 1961 · S/N 18253222 N8833XGrommet Michael J · Cascade, IDBuilt 1961 · S/N 18253233 N8834XRegistration Pending · Shawnee, OKRegistration pendingBuilt 1960 · S/N 18253234 N8835XBechtel Jerold L · Snover, MIS/N 18253235 N8837XRichards Kevin J · Magnolia, TXBuilt 1961 · S/N 18253237 N8838XAdventist World Aviation Inc · Wilson, NCBuilt 1961 · S/N 18253238 N8839XAlexander Ray J · Battle Ground, WABuilt 1961 · S/N 18253239 N8840XSb Enterprise LLC · Marshall, TXBuilt 1961 · S/N 18253240 N8841XAngelone Inc · Elkhart, INS/N 18253241 N8843XDavis James S · Reno, NVBuilt 1960 · S/N 18253243 N8844XMangum Larry M · Morristown, TNBuilt 1961 · S/N 18253244 N8845XByerly Charles W · Joliet, MTS/N 18253245 N8848XLevesque Michael C · Hampden, MEBuilt 1961 · S/N 18253248 N8849XCopper River Airmotive LLC · Copper Center, AKBuilt 1961 · S/N 18253249 N8850XBossola Raymond L · Suffolk, VABuilt 1961 · S/N 18253250

Back to Cessna 182D