Skip to content

Registered aircraft · 101

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

N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932 N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921 N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875 N210EAFollis Allen J · San Tan Valley, AZBuilt 1962 · S/N 21057973 N450DHHewitt Rod · Federal Way, WAS/N 21057998 N456DHWilliams Metal And Machinery LLC · Irvington, ALS/N 21058042 N6100BParas Mark J · Camas, WAS/N 21058068 N65MPWard Gerald · Austin, TXS/N 21057904 N9543XBarth Samuel · Fonda, NYS/N 21057843 N9544XB&B Aviation LLC · Arlington, WABuilt 1961 · S/N 21057844 N9545XRichardson Dana C · Okeechobee, FLBuilt 1961 · S/N 21057845 N9547XCundiff Zackery A · Klamath Falls, ORBuilt 1962 · S/N 21057847 N9548XMclenaghan Alvin · Phoenix, AZBuilt 1962 · S/N 21057848 N9553XMccarthy Sean P · Jacksonville Beach, FLBuilt 1962 · S/N 21057853 N9561XAirxn LLC · Williams, AZBuilt 1962 · S/N 21057861 N9562XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057862 N9563XGraham Raymond S · Citra, FLBuilt 1962 · S/N 21057863 N9565XBerkbiegler Allen L · Lonedell, MOBuilt 1962 · S/N 21057865 N9569XStepair LLC · Spring Valley, OHBuilt 1962 · S/N 21057869 N9570XGroves Chandler H DBA · Farmington, CAS/N 21057870 N9571XBarnett David Kirk · Brock, TXS/N 21057871 N9572XSparks James D · Glennallen, AKBuilt 1962 · S/N 21057872 N9574XFlying Nova LLC · Anchorage, AKS/N 21057874 N9578XTvat LLC · Sun City, AZS/N 21057878 N9580XNewman Michael Mcdermott II · Campo, CABuilt 1962 · S/N 21057880 N9586XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057886 N9587XFulminare Aviation LLC · Ocala, FLBuilt 1962 · S/N 21057887 N9588XHanson Roger D · Seattle, WABuilt 1962 · S/N 21057888 N9589XFishel Thomas N Trustee · Reno, NVBuilt 1962 · S/N 21057889 N9591XSparrow William L · Pike Road, ALBuilt 1962 · S/N 21057891 N9592XLewis Carroll G Jr · Waxahachie, TXS/N 21057892 N9593XWhite Andrew W · Silverdale, WAS/N 21057893 N9596XStulken Merrill · Curtis, WABuilt 1962 · S/N 21057896 N9597XDavidson Ronald A · Pueblo West, COS/N 21057897 N9598XOdell Eugene S · Yakima, WABuilt 1962 · S/N 21057898 N9601XCervantes Jose M · San Diego, CAS/N 21057901 N9602XMorehouse Darrell L · Glasgow, MTBuilt 1962 · S/N 21057902 N9603XTerry Nickolas B · Maize, KSBuilt 1962 · S/N 21057903 N9605XTony Flies Inc · Sparta, NCBuilt 1962 · S/N 21057905 N9606XRowland Douglas · Wichita, KSS/N 21057906 N9607XBaldridge Steven J · Edmonds, WAS/N 21057907 N9608XEsdaile Philip J · Woodland, CABuilt 1962 · S/N 21057908 N9610XSutton George E · Fullerton, CABuilt 1961 · S/N 21057910 N9611XWinston Air LLC · Haleyville, ALS/N 21057911 N9614XMountain Air Flying LLC · Brigham City, UTBuilt 1962 · S/N 21057914 N9616XJim Barrett Photography Inc · Honolulu, HIBuilt 1961 · S/N 21057916 N9626XPortman Joe · Elmendorf, TXBuilt 1962 · S/N 21057926 N9627XW J Bolton Farms LLC · Marked Tree, ARBuilt 1962 · S/N 21057927 N9634XScoggin Gerald William III · Port Saint Lucie, FLBuilt 1962 · S/N 21057934 N9637XCypress Peak LLC · Pickens, MSBuilt 1962 · S/N 21057937

Back to Cessna 210B