Skip to content

Registered aircraft · 913

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

N4163ASalida Aviation Partnership Group · Moffat, COBuilt 1970 · S/N D-9121 N4164SFabien Turpaud Corp · Lewes, DEBuilt 1975 · S/N D-9753 N4175SBauman Loren A · Lewisville, NCS/N D-9756 N4177SMiles Insurance Inc · Inverness, ILBuilt 1975 · S/N D-9757 N4180SPalomino Princess Express LLC · Helena, MTS/N D-9755 N4187SJ&S Aviation Services LLC · Hastings, NES/N D-9765 N4192ARocky Mountain Aviation Inc · Wilmington, DEBuilt 1970 · S/N D-9128 N4192SStecklein Aviation LLC · Colleyville, TXBuilt 1975 · S/N D-9766 N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762 N41CMClark Patrick L · Kenai, AKBuilt 1977 · S/N D-9967 N4212SColburn Reno Bryan · Turner, MTBuilt 1976 · S/N D-9954 N4217SAnla Aviation LLC · Bentonville, ARBuilt 1977 · S/N D-9968 N4245AMac Flight LLC · Conway, ARBuilt 1970 · S/N D-9126 N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959 N4275SEvergreen Aviation LLC · Franktown, COBuilt 1977 · S/N D-9961 N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850 N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934 N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969 N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306 N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140 N4301WNash Matthew · Edmonds, WABuilt 1974 · S/N D-9578 N4302WDagenhart Ronald Jason · Westerville, OHBuilt 1974 · S/N D-9582 N4310SVelk Vincent F · Havre, MTBuilt 1975 · S/N D-9773 N4312WBreitbarth Brian · Canby, ORBuilt 1974 · S/N D-9585 N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587 N4322WSnell Steve · Scotts Valley, CABuilt 1974 · S/N D-9589 N4340WHanger Aviation Inc · Charleston, SCBuilt 1974 · S/N D-9577 N4342AR&B Air LLC · Clayton, MOBuilt 1970 · S/N D-9133 N4366WPrentice Chris · Independence, ORBuilt 1974 · S/N D-9620 N436JB700p LLC · Lewes, DEBuilt 1976 · S/N D-9884 N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626 N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600 N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256 N4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141 N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911 N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142 N4419AMccants Robley D · Mesa, AZS/N D-9147 N4427WRockwall LLC · Wye Mills, MDBuilt 1974 · S/N D-9605 N4430WMagerit Aviation Inc · South Boston, MABuilt 1974 · S/N D-9609 N4431WUnited Roofing Of Central Florida Inc · Ocala, FLBuilt 1974 · S/N D-9606 N4432ABrown David L · Gold Hill, NCBuilt 1970 · S/N D-9144 N4435VMacdonald Glenn · Sugar Land, TXFirst renewal noticeBuilt 1979 · S/N D-10225 N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIBuilt 1974 · S/N D-9590 N444DGSwanson Douglas A · Marana, AZS/N D-9882 N444DKPiggott Russell T · Fresno, CABuilt 1979 · S/N D-10296 N444DWTriple 4 Dw LLC · Davie, FLBuilt 1972 · S/N D-9416 N444RUFitzgerald Paul · Grapevine, TXBuilt 1973 · S/N D-9441 N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783 N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012 N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611

Back to Beech V35B