Skip to content

Registered aircraft · 1,565

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

N735ALGml Flight Service LLC · Las Cruces, NMBuilt 1976 · S/N 18265270 N735AMJohnson Mark S · Bremerton, WABuilt 1976 · S/N 18265271 N735ANAmerican Eagle Flying Club · New Hudson, MIBuilt 1976 · S/N 18265272 N735APJay Bee Aviation LLC · Okeechobee, FLBuilt 1976 · S/N 18265273 N735ARHaller Michael J · Clayton, NCBuilt 1976 · S/N 18265275 N735ASBlok Roelof · Ocala, FLBuilt 1976 · S/N 18265276 N735AUScott Creek LLC · Snohomish, WABuilt 1976 · S/N 18265278 N735AVArmellini Frank Patrick · Fallbrook, CABuilt 1976 · S/N 18265279 N735AWDesert Dog Signs LLC · Ogden, UTBuilt 1976 · S/N 18265280 N735AYFlight LLC · Las Vegas, NVS/N 18265282 N735AZYellowstone Aviation Inc · Jackson, WYBuilt 1976 · S/N 18265283 N735BAWheels Up Aviation Inc · Arlington Heights, ILBuilt 1976 · S/N 18265284 N735BESmith Cullen M · Framingham, MABuilt 1976 · S/N 18265288 N735BFMedvigy Gary A Trustee · Camas, WABuilt 1976 · S/N 18265289 N735BHEfinger John M · Cresson, TXS/N 18265291 N735BJSpirit Avionics Ltd · Gahanna, OHS/N 18265292 N735BLThomas John D · Jasper, TNBuilt 1976 · S/N 18265294 N735BPMacon Air LLC · Franklin, NCBuilt 1976 · S/N 18265297 N735BQSayre Daniel E · Mckinleyville, CABuilt 1976 · S/N 18265298 N735BRCooper Kevin J · Kingsport, TNBuilt 1977 · S/N 18265299 N735BULinebarger Daniel R · Granbury, TXBuilt 1976 · S/N 18265302 N735BWWilliams Frank · Kerrville, TXBuilt 1976 · S/N 18265304 N735BXRajotte Leith Gaines · Hood River, ORBuilt 1976 · S/N 18265305 N735BYRegistered aircraftBuilt 1976 · S/N 18265306 N735BZBuckner Steven W · Gatesville, TXBuilt 1976 · S/N 18265307 N735CCHardeman Brian · Manhattan, KSBuilt 1976 · S/N 18265310 N735CFG & M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 18265313 N735CGBumpah Aviation LLC · Ardmore, OKBuilt 1976 · S/N 18265314 N735CHMckelvey Charles Y · Little Egg Harbor, NJBuilt 1976 · S/N 18265315 N735CJNorthgate Aviation LLC · San Antonio, TXBuilt 1976 · S/N 18265316 N735CKLickety-Split LLC · Celebration, FLBuilt 1976 · S/N 18265317 N735CLSprinkler Shop Inc · Paul, IDBuilt 1976 · S/N 18265318 N735CQKanaps LLC · Huntsville, ALBuilt 1976 · S/N 18265322 N735CRMcdaniel Erick · Fort Worth, TXBuilt 1976 · S/N 18265323 N735CSGoldsky 1 LLC · Maitland, FLBuilt 1976 · S/N 18265324 N735CUGross Thomas E · Mooresville, NCS/N 18265326 N735CVYocham Scott · Mcgregor, TXBuilt 1976 · S/N 18265327 N735CXInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 18265329 N735CYSocal Aviators LLC · Fullerton, CABuilt 1976 · S/N 18265330 N735CZPearl 3022 LLC · Lady Lake, FLBuilt 1976 · S/N 18265331 N735DBSailsbery Brett E · San Clemente, CABuilt 1977 · S/N 18265333 N735DCWysocki Alice R · Ellington, CTBuilt 1977 · S/N 18265334 N735DFHd Legacy LLC · Richvale, CABuilt 1976 · S/N 18265337 N735DGEricson Jay S · Eagan, MNBuilt 1976 · S/N 18265338 N735DJPinckert Thomas · Potomac, MDS/N 18265339 N735DKGraziani Frank L · Hot Springs, ARFirst renewal noticeBuilt 1977 · S/N 18265340 N735DLGeorge Robert C · Woodway, TXBuilt 1977 · S/N 18265341 N735DQCampbell James T · Astoria, ORBuilt 1977 · S/N 18265345 N735DUCarmel Aviation Inc · Boise, IDS/N 18265349 N735DVRed Baron Flyes Inc · Caledonia, MNBuilt 1977 · S/N 18265350

Back to Cessna 182Q