Skip to content

Registered aircraft · 234

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

N30549Lad Custom Publishing Inc · Buford, GABuilt 1973 · S/N 21059932 N30583Roviaro Edward · Schererville, INBuilt 1973 · S/N 21059936 N30593Valiair Lc Trustee · Casper, WYBuilt 1973 · S/N 21059938 N307CFSchwarzenberg Johannes · Helena, MTFirst renewal noticeBuilt 1973 · S/N 21059961 N30EWThree Zero Echo Whisky Inc · Wilmington, DEBuilt 1976 · S/N 21061412 N333JWPhillips John Patrick · Cumming, GABuilt 1975 · S/N 21061094 N346CBKombi Brazil Inc · Fort Lauderdale, FLS/N 21060712 N35498Ray Arthur G · Springdale, ARBuilt 1973 · S/N 21059996 N35677C3 Indutries LLC · Bakersfield, CABuilt 1973 · S/N 21060007 N35806Air Dakota Flite Inc · Hettinger, NDBuilt 1973 · S/N 21060011 N373HShumate Johnny E · Spring, TXBuilt 1974 · S/N 21060190 N397MSGregory Wm Broburg Ltd · Minneapolis, MNS/N 21061449 N3UFAltorfer David W · Peoria, ILBuilt 1976 · S/N 21061410 N400GTDelaney Holdings LLC · De Witt, IABuilt 1971 · S/N 21059544 N412TRoberts Gregory · Scottsdale, AZBuilt 1972 · S/N 21059558 N429DLLandset David J · West Palm Beach, FLBuilt 1975 · S/N 21060649 N444CLK G L Aviation Inc · Villisca, IABuilt 1975 · S/N 21060910 N444PJWagner Aviation LLC · Laura, OHBuilt 1974 · S/N 21060433 N44CFFly Low Aviation LLC · Smithville, MSS/N 21059764 N453MCMcneil Kenneth A · Fort Meade, FLS/N 21059844 N4605QRichs Air Service · Victoria, KSBuilt 1971 · S/N 21059505 N4621QFitzgerald Barry Eugene · Springfield, ILBuilt 1971 · S/N 21059521 N4622QBas Part Sales LLC · Greeley, COS/N 21059522 N4624QBowen Kennith M II Trustee · Winters, CABuilt 1971 · S/N 21059524 N4625QBank Of Utah Trustee · Salt Lake City, UTBuilt 1971 · S/N 21059525 N4639QGrundmann Karl · Manassas, VABuilt 1971 · S/N 21059539 N4654QStapleton Mark Christopher · Vestavia Hills, ALBuilt 1972 · S/N 21059554 N4677QDahl Larry A · Cogswell, NDBuilt 1972 · S/N 21059577 N4689QJohnson Tod W · Three Rivers, CABuilt 1972 · S/N 21059589 N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105 N47TCWright Frank David · Sequin, TXBuilt 1975 · S/N 21061028 N4DXHuffman Aviation & Equipment LLC · Marietta, GABuilt 1972 · S/N 210-59600 N5037VPoh Enterprises LLC · Gardena, CABuilt 1975 · S/N 21060824 N5091VWilliams Timothy J · Fernandina Beach, FLBuilt 1975 · S/N 21060833 N5120VTreaster Implement Co Inc · Beloit, KSBuilt 1975 · S/N 21060839 N512ATRanch Aero LLC · Sterling City, TXBuilt 1975 · S/N 21060721 N5139QNykerk Kory · San Miguel, CABuilt 1972 · S/N 21059639 N5146QJ&G Aero Investments Group LLC · Wilmington, DEBuilt 1972 · S/N 21059646 N515HE2f Trade LLC · Gainesville, TXS/N 21061457 N5171VLisenbey Edward · Caldwell, IDS/N 21060846 N5198VMaddock Jay B · Sugar Grove, ILS/N 21060859 N51CMCorley W Michael · Mc Minnville, TNBuilt 1972 · S/N 21059628 N5217VScrobola Air LLC · Wyoming, PABuilt 1975 · S/N 21060863 N521BWBilmar Avionics Inc · Kissimmee, FLBuilt 1974 · S/N 21060297 N5277VLechner Gary D · Woodstock, ILBuilt 1975 · S/N 21060892 N5281VOne Vector LLC · Wolcott, COBuilt 1975 · S/N 21060896 N5318VTyson Ron A · Fredericksburg, TXBuilt 1975 · S/N 21060906 N536WCN8qb LLC · Thief River Falls, MNBuilt 1972 · S/N 21059794 N5400VWilson Darryl M · Granger, INFirst renewal noticeS/N 21060935 N5434VInhouse Graphics Inc · Brookshire, TXBuilt 1975 · S/N 21060947

Back to Cessna 210L