Skip to content

Registered aircraft · 1,605

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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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.

N101GRAlshamari Ahmad M · San Mateo, CABuilt 1946 · S/N 9749 N1044GVoelkerding William Michael · Fairbanks, AKS/N 14403 N110VSbur David A · Vancouver, WABuilt 1946 · S/N 8748 N110XPlayter Bud W DBA · Gowen, MIBuilt 1946 · S/N 10449 N111GZRabinowitz Warren · Ramrod Key, FLS/N 14756 N111NZBlackerby Kevin W · Spicewood, TXBuilt 1947 · S/N 12372 N1143UOman Lee · Sequim, WAS/N 11652 N1147QGraber Quinten R · Brooksville, MSBuilt 1947 · S/N 12785 N115JFFields Joseph H · Placerville, CAS/N 13498 N1267NGraff Nathan A · Kelso, WAS/N 14298 N12XZ140 LLC · Birmingham, ALS/N 13182 N138JJWard Gary P · Lincolnton, GABuilt 1946 · S/N 8035 N1408UAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1948 · S/N 14989 N140BTThomas Raymond · Deer Park, WAS/N 8478 N140CWind Paul K · Chesterfield, MOS/N 12501 N140CBVintage Aircraft LLC · Gilbert, SCBuilt 1947 · S/N 12994 N140CEClawson Duane W · Enon Valley, PAS/N 12928 N140CLBennett Bob J · Greenville, WIS/N 11485 N140CRWills William J · Cape Coral, FLS/N 9928 N140CSIsrael Oscar M · Sinton, TXS/N 14641 N140DConant Stephen · Nyssa, ORBuilt 1946 · S/N 8395 N140DFBitikofer Brent E · Kansas City, KSS/N 14439 N140DTKing Jeremy S · Rainier, WABuilt 1946 · S/N 8006 N140DWMuriithi Peter K · Middle River, MDBuilt 1946 · S/N 8143 N140EDThompson Randy L · Anderson, CABuilt 1946 · S/N 11148 N140EWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 9727 N140FLittlefield Molly Flanagan · Kent, WABuilt 1946 · S/N 9179 N140GStong Douglas R · Collegeville, PABuilt 1946 · S/N 8266 N140JHOhlin Christian A · Sebastopol, CABuilt 1946 · S/N 10223 N140JTChristianson Alan J · Camas, WAS/N 10711 N140JZLawrence John Z · Kingston Springs, TNBuilt 1946 · S/N 11380 N140LBBerry Brian R · Tahlequah, OKBuilt 1946 · S/N 10677 N140LDMazankowski Lara R · San Diego, CABuilt 1946 · S/N 10929 N140MENorah Bridget · Snoqualmie, WABuilt 1946 · S/N 8044 N140MTHoover Josiah E · Wasilla, AKBuilt 1947 · S/N 12905 N140MWWeyant Charles B · Santa Maria, CAS/N 9845 N140NJames Justin C · Pima, AZBuilt 1947 · S/N 14026 N140NSSwann Neal P · Plymouth, CAS/N 14908 N140PClass A Coaches LLC · Missoula, MTBuilt 1947 · S/N 13855 N140PRBlue Sky Air LLC · Queen Creek, AZBuilt 1946 · S/N 9440 N140QSchroeder Peter G · Clemmons, NCBuilt 1946 · S/N 9748 N140SGGault Scott J · Norcross, GABuilt 1946 · S/N 11573 N140SKRon Alexander Youth Aviation Program · Williamson, GABuilt 1947 · S/N 12835 N140TGRounds Chris · Waller, TXBuilt 1946 · S/N 9433 N140TJSetter Thomas D · Burnsville, MNS/N 12645 N140TMKauffman Marvin Paul · Brooksville, MSS/N 10580 N140TWRegistration Pending · Burlington, NCRegistration pending, pending cancellationBuilt 1947 · S/N 12403 N140VMaggart Daniel J · Winchester, ILS/N 14291 N140WYWilson J Brent Trustee · Lander, WYBuilt 1947 · S/N 12865 N140XRegistration Pending · Scottsbluff, NERegistration pendingS/N 11387

Back to Cessna 140