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

N737JBemis Susan · Newhall, CABuilt 1978 · S/N R18200842 N737JKJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1978 · S/N R18200836 N737JLN737jl LLC · Dimmitt, TXBuilt 1978 · S/N R18200837 N737JNSurplus Products Inc · East Point, KYBuilt 1978 · S/N R18200838 N737JTColman Ronin B · Arlington, TXBuilt 1978 · S/N R18200840 N737LMMccoy James R · Blue Mound, ILBuilt 1978 · S/N R18200845 N737MKBookout Brent · Bakersfield, CABuilt 1978 · S/N R18200852 N737MXCason Patrick · Las Vegas, NVBuilt 1978 · S/N R18200855 N737MZTed Noble Construction · Truckee, CABuilt 1978 · S/N R18200856 N737NYDraper Gregory W · Oklahoma City, OKBuilt 1979 · S/N R18200863 N737PSCozumel Leasing LLC · Wilmington, DEBuilt 1979 · S/N R18200868 N737QHPhilbrick Rodney C DBA · Bishop, CABuilt 1979 · S/N R18200873 N737TAThomas Gregory Shan · El Paso, TXBuilt 1979 · S/N R18200880 N737TBBartholemy Construction Inc · Beaverton, ORBuilt 1979 · S/N R18200881 N737UBMeyeres Farms LLC · Chase, KSBuilt 1979 · S/N R18200883 N737VTHudson Gary L · Lake Havasu City, AZBuilt 1979 · S/N R18200886 N737VXL&G Aviation LLC · Fresno, CABuilt 1979 · S/N R18200888 N737WNMorton Jeremy R Jr · Stamford, CTBuilt 1979 · S/N R18200891 N737WV737wv LLC · New Braunfels, TXS/N R18200892 N737XDCraig K Dpe LLC · Kaaawa, HIBuilt 1979 · S/N R18200893 N737YXTichenor Warren White II · Auburn, WABuilt 1979 · S/N R18200897 N738ABRiner Charles Daniel · Blountville, TNS/N R18200902 N738ASLickteig Frederic W · Falls Church, VABuilt 1979 · S/N R18200904 N738BDA Street LLC · Arden Hills, MNBuilt 1979 · S/N R18200906 N738BKSchatzle Gregory E · Chelsea, MIBuilt 1979 · S/N R18200907 N738BQKiefer James A · Mckinney, TXBuilt 1979 · S/N R18200908 N738CUMiller Barton P · Madison, WIBuilt 1979 · S/N R18200912 N738ERJ A Brooks LLC · White Lake, MIBuilt 1979 · S/N R18200918 N738FHNickel Bush Enterprises LLC · Walla Walla, WABuilt 1979 · S/N R18200920 N738HCPlane And Simple Holdings LLC · Saint Petersburg, FLBuilt 1979 · S/N R18200927 N738JZRegistration Pending · Washington, UTRegistration pendingBuilt 1979 · S/N R18200935 N738LSKingfisher Assurance LLC · Fort Worth, TXBuilt 1979 · S/N R18200939 N738LUUrquhart Air LLC · Parker, COS/N R18200940 N738NQSimmons Calvin L · Washington, UTBuilt 1979 · S/N R18200945 N738NSGibson Field · Paso Robles, CABuilt 1979 · S/N R18200947 N738PKTss Flying Club Inc · Bethesda, MDBuilt 1979 · S/N R18200950 N738PWLamey Kevin P Trustee · Missoula, MTS/N R18200952 N738QVChristensen Gerald T Trustee · Elk Grove Village, ILBuilt 1979 · S/N R18200955 N738RSGentzler Charles R · Thousand Oaks, CABuilt 1979 · S/N R18200957 N738TYForest Structural Engineering Inc · Boston, MABuilt 1979 · S/N R18200959 N738VGTepper Steven · Freehold, NJBuilt 1979 · S/N R18200965 N738VTStrutin Millard Desmond · Hackettstown, NJBuilt 1979 · S/N R18200966 N738VWAwnf LLC · Burleson, TXBuilt 1979 · S/N R18200967 N738WVJohnston John A · Raleigh, NCBuilt 1979 · S/N R18200971 N738XCLance Vaculin LLC D/B/A · Murray, UTBuilt 1979 · S/N R18200972 N738XNLuther Edwin H · Bristol, TNBuilt 1979 · S/N R18200973 N739BYHerling Edward Keith · Highland Lake, NYBuilt 1979 · S/N R18200984 N739CQShumway Richard L Trustee · Casper, WYBuilt 1979 · S/N R18200988 N739CVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N R18200989 N739DCSale Reported · Mount Sterling, ILSale reportedS/N R18200991

Back to Cessna TR182