Skip to content

Registered aircraft · 465

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

N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050 N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057 N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689 N4978YBohannon Donald S · Moreland, GAS/N 21064063 N4981CWatson Michael · Dalhart, TXS/N 21063699 N49STHedeen Arnold R · Seattle, WAS/N 21064844 N4YYWilliams Scott Griffin · Salt Lake City, UTBuilt 1979 · S/N 21063553 N504JWPalmer Gary H · San Juan, TXBuilt 1981 · S/N 21064232 N5086ANeeley James L · Temecula, CAS/N 21063263 N5089C5089c LLC · Fairhope, ALBuilt 1979 · S/N 21063701 N508TCFisher Travis L · Odessa, TXBuilt 1982 · S/N 21064741 N5105YMcduff Douglas M · Cook, MNBuilt 1980 · S/N 21064074 N5106CQuest Aviation Inc · Lake City, FLBuilt 1979 · S/N 21063704 N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705 N510WFFuel Center Plus Inc · Silver City, NMBuilt 1980 · S/N 21064140 N5119YWby Aviation LLC · Lewes, DES/N 21064083 N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034 N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280 N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087 N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851 N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289 N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100 N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292 N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294 N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302 N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114 N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304 N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602 N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305 N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306 N5217CHydro Wings Inc · Valle Crucis, NCBuilt 1979 · S/N 21063719 N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316 N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399 N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717 N5252ALong Harold M · Carson City, NVBuilt 1979 · S/N 21063327 N5260AN5260a LLC · Los Angeles, CAS/N 21063333 N5264CCullum Transportation LLC · North Charleston, SCBuilt 1979 · S/N 21063725 N5274YMba Sales LLC · Ridgefield, WABuilt 1980 · S/N 21064147 N5276AOstermeier Brigitte · MaunNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 21063341 N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349 N5287YMorrow Aviation LLC · Midland, TXS/N 21064152 N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356 N5313USky Quest 210 LLC · Clarksdale, MSBuilt 1984 · S/N 21064862 N5317ABlue Skies Air LLC · Allen, TXBuilt 1979 · S/N 21063365 N5318ABuchanan Harvey · Townsend, MABuilt 1979 · S/N 21063366 N5323URio Farms LLC · King City, CABuilt 1984 · S/N 21064865 N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164 N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171 N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376 N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871

Back to Cessna T210N