Skip to content

Registered aircraft · 2,099

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

N9914MLabra Victor David · Mesa, AZS/N 18264810 N9915MBoone John G · Goleta, CABuilt 1976 · S/N 18264811 N9916ESchult Jessica Elaine · Boise, IDBuilt 1975 · S/N 18263976 N9917ESopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1975 · S/N 18263977 N9919EN9919e LLC · Rio Vista, TXBuilt 1975 · S/N 18263979 N9921EBigelow Jason A · Woodstock, ILBuilt 1975 · S/N 18263981 N9925EMeredith Dean J · Boynton Beach, FLBuilt 1975 · S/N 18263985 N9928EAir-Lark Inc · Fort Walton Beach, FLBuilt 1975 · S/N 18263988 N9929EJesse Briggs Inc · Stuttgart, ARS/N 18263989 N992LBBravo Initiative LLC · Highlands Ranch, COBuilt 1975 · S/N 18263982 N992WTAngle Of Attack Inc · Santa Fe, NMBuilt 1972 · S/N 18261200 N9932EMiller Mike R · Redmond, WABuilt 1975 · S/N 18263992 N9934EStenger D James Trustee · Sonora, CABuilt 1975 · S/N 18263994 N993GAUtopia Flyers LLC · Utopia, TXBuilt 1972 · S/N 18261152 N9940ESaint Louis University · Saint Louis, MOBuilt 1975 · S/N 18264000 N9944ESw Aviation LLC · Norman, OKBuilt 1975 · S/N 18264004 N9946ELorenz Gary W · La Mesa, CABuilt 1975 · S/N 18264006 N9947EAstle James H · St John, KSBuilt 1975 · S/N 18264007 N9951EBlue Skylane LLC · Sunriver, ORBuilt 1975 · S/N 18264011 N9953ESutton Gregg S · Orono, MNBuilt 1975 · S/N 18264013 N9954EChase Ronald L · Payson, AZBuilt 1975 · S/N 18264014 N9955ESanchez Angel David · Houston, TXBuilt 1975 · S/N 18264015 N9956EBankuti Steve A · Littlerock, WABuilt 1975 · S/N 18264016 N9958EAirtauk LLC · Montauk, NYBuilt 1975 · S/N 18264018 N9959ETyler Matthew S · Lakeside, CABuilt 1975 · S/N 18264019 N995SBRossi Randall A · Georgetown, TXBuilt 1974 · S/N 18262473 N9962ESynergy Financial Services Inc · Vancouver, WABuilt 1975 · S/N 18264022 N9964EJansen Christopher · Stilwell, KSBuilt 1975 · S/N 18264024 N9968EReeder Joseph · Northfield, MNBuilt 1975 · S/N 18264028 N9979EFitzgerald Brett · Wellsville, UTBuilt 1975 · S/N 18264039 N9980ERapid Flyers LLC · Zionsville, INBuilt 1975 · S/N 18264040 N9984EVelasco Timoteo W · South Jordan, UTBuilt 1975 · S/N 18264044 N9989ET Craft Aero Club Inc · Nampa, IDBuilt 1975 · S/N 18264049 N9990EN9990e LLC · Alva, FLBuilt 1975 · S/N 18264050 N9992EWoods Charles D · Huffman, TXBuilt 1975 · S/N 18264052 N9992GDaneker Adin · Kalispell, MTBuilt 1974 · S/N 18263451 N9994EBeard Michael W · Eveleth, MNBuilt 1975 · S/N 18264054 N9995EWilliams Dean W · Punta Gorda, FLBuilt 1975 · S/N 18264055 N9996EMeier Sally A · Lac Du Flambeau, WIBuilt 1975 · S/N 18264056 N9997EAir Data Solutions LLC · Natchitoches, LABuilt 1975 · S/N 18264057 N999DGFoghorn Airfleet LLC · Columbus, INBuilt 1973 · S/N 18261688 N999JJAlpine Holdings LLC · Kalispell, MTBuilt 1976 · S/N 18264642 N999UCLinville Rex D Trustee · Sarasota, FLBuilt 1973 · S/N 18261957 N99MVWinkler Gabriel M · Kailua Kona, HIBuilt 1975 · S/N 18263592 N99YED & E Recreation LLC · Dowling, MIBuilt 1975 · S/N 18264030 N9BPLynn Marshall · Milford, MIBuilt 1973 · S/N 18262078 N9RPMalmberg Wendell A · Snohomish, WABuilt 1973 · S/N 18262525 N9SWWilliamson Shane Trustee · Grants Pass, ORBuilt 1974 · S/N 18263118 N9TLGospel Ministries International Inc · Collegedale, TNBuilt 1973 · S/N 18262680

Back to Cessna 182P