Skip to content

Registered aircraft · 1,065

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

N6894FSudduth Robert J · Huachuca City, AZBuilt 1966 · S/N 15063494 N6895FFaber Elgin J · Havre, MTBuilt 1966 · S/N 15063495 N6896FLandmesser Avis C · Troy, MIBuilt 1966 · S/N 15063496 N6900FIngle Glenn A · Ypsilanti, MIBuilt 1966 · S/N 15063500 N6908FFrickel Thomas L · Bristow, NEBuilt 1966 · S/N 15063508 N6909FCosgriff Kevin R · Midway, KYS/N 15063509 N6911FOlson Richard S · Massena, NYBuilt 1966 · S/N 15063511 N6914FStephens Nicholas J · Santa Rosa, CABuilt 1966 · S/N 15063514 N6915FTillison Glenda L · Cameron Park, CABuilt 1966 · S/N 15063515 N6921FAndrade Alexander S · Pleasant Grove, UTBuilt 1966 · S/N 15063521 N6925FRzucidlo Trevor A · Dayville, CTBuilt 1966 · S/N 15063525 N6928MJohnson Mark D · Onondaga, MIBuilt 1965 · S/N 15062448 N6929FRyberg Keith C · Portales, NMBuilt 1966 · S/N 15063529 N6930FWright Dale D · Wallace, KSBuilt 1966 · S/N 15063530 N6935FWood Roger E · Waxhaw, NCBuilt 1966 · S/N 15063535 N6937FSale Reported · Rockton, ILSale reportedS/N 15063537 N6939FPayne Billy Jack · Powhatan, VABuilt 1966 · S/N 15063539 N6941FMorgan Stuart G · Spring Valley, CABuilt 1966 · S/N 15063541 N6946F46fox Aviation LLC · Bedminster, NJBuilt 1966 · S/N 15063546 N6948FLee Ethan · Millsap, TXBuilt 1966 · S/N 15063548 N6949FConaway Byron Richard · Savannah, TNS/N 15063549 N6950FRgv Flight Academy LLC · Bayview, TXBuilt 1966 · S/N 15063550 N6952FSkalsky Nathan · Tigard, ORBuilt 1966 · S/N 15063552 N6954FRegistration Pending · Sumner, WARegistration pendingBuilt 1966 · S/N 15063554 N6957FRussell Clyde R Jr DBA · Montrose, ARS/N 15063557 N6960FFirst Waypoint LLC · Mckinney, TXS/N 15063560 N6962FSiegrist Gary D · Belvidere, ILS/N 15063562 N6965FJefferies Vincent B · Rock Springs, WYBuilt 1966 · S/N 15063565 N6969FBrannan William C · Temecula, CAS/N 15063569 N6971FSutton Marshall T · Erick, OKBuilt 1966 · S/N 15063571 N6972FHirsch T W III · Farmers Branch, TXBuilt 1966 · S/N 15063572 N6976FCalder Mark A · Midlothian, TXBuilt 1966 · S/N 15063576 N6977FRice Dennis L · Crawfordsville, INBuilt 1966 · S/N 15063577 N6980FEnvii Aviation LLC · Monroe, WAS/N 15063580 N6987FGacesa Samuel M · Belton, TXBuilt 1966 · S/N 15063587 N6988FPaulson Allerton · Anoka, MNBuilt 1966 · S/N 15063588 N6990FWohlers Paul A · Calimesa, CABuilt 1966 · S/N 15063590 N6991FMeyer George D · Paradise, CAS/N 15063591 N6992FJenkins Seth A · Charlotte, NCBuilt 1966 · S/N 15063592 N6993FBordens Jacob R · Chatham, NJBuilt 1966 · S/N 15063593 N6994FHerring Jason D · Wasilla, AKS/N 15063594 N6997FSmith Roger D · Fayetteville, NCBuilt 1966 · S/N 15063597 N6999FHabibi Airlines LLC · San Juan, PRBuilt 1966 · S/N 15063599 N6MTSchwartz Amy A · Chandler, AZBuilt 1966 · S/N 15062848 N7002FMcdonald Timothy M · Meredith, NHBuilt 1966 · S/N 15063602 N7005FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063605 N7011FGlow Medspa LLC · Spring Hill, TNS/N 15063611 N7019FShore Luke S · Thurmond, NCS/N 15063619 N7030FPaul William · Windfall, INBuilt 1966 · S/N 15063630 N7039FWharam Glen A · Park River, NDBuilt 1966 · S/N 15063639

Back to Cessna 150F