Skip to content

Registered aircraft · 756

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

N23305Fuhrmann Brandon R · Aberdeen, SDBuilt 1968 · S/N 15068863 N23308Hotel Bravo Aviation LLC · Sumrall, MSBuilt 1968 · S/N 15068864 N23311Sweeney Daniel W · Broad Brook, CTBuilt 1968 · S/N 15068866 N23322Lopez William Alberto · Miami, FLBuilt 1968 · S/N 15068873 N23323Boccaccio Peter Anthony · Burke, SDBuilt 1968 · S/N 15068874 N23324Walden James F · Willcox, AZBuilt 1968 · S/N 15068875 N23328Scmitt Rudy · Brookshire, TXBuilt 1968 · S/N 15068876 N23329Welles Richard V · Elmira, NYBuilt 1968 · S/N 15068877 N23330N23330 LLC · Bedford, PABuilt 1968 · S/N 15068878 N23333Leading Edge Aviation LLC · Lewiston, IDBuilt 1968 · S/N 15068880 N23337Mosquito LLC · Chesaning, MIBuilt 1968 · S/N 15068883 N23344Hmh Consolidated LLC · Lake Placid, FLBuilt 1968 · S/N 15068888 N23348Noel Tom W · Galloway, OHBuilt 1968 · S/N 15068890 N23349Fairwinds Aviation LLC · Goldsboro, NCBuilt 1968 · S/N 15068891 N23350Kimbrel Martin E · Oakville, WABuilt 1968 · S/N 15068892 N23357603 Flight LLC · Nashua, NHS/N 15068898 N23359Moore Everett A · New Lexington, OHBuilt 1968 · S/N 15068900 N23360Xc Aviation LLC · Wyckoff, NJBuilt 1968 · S/N 15068901 N23364Ephraim Flyers Inc · Ephraim, WIBuilt 1968 · S/N 15068904 N23365Del Rossa Erwin R · Sodus, NYBuilt 1968 · S/N 15068905 N23370Carruthers John H Jr · Berlin, NHBuilt 1968 · S/N 15068909 N23372Dold Stephen E · Foresthill, CABuilt 1968 · S/N 15068911 N23374Pannell Lucas J · Midland City, ALBuilt 1968 · S/N 15068913 N23382Galster Scott · Oneonta, NYBuilt 1968 · S/N 15068918 N23386Perta Steven J · Rome, NYBuilt 1968 · S/N 15068920 N23387Strickland Kim A · Bowling Green, OHBuilt 1968 · S/N 15068921 N23390Smp LLC · Kenner, LAS/N 15068924 N23391Porter Scott · Aguila, AZBuilt 1968 · S/N 15068925 N23392Mullins Adrian · Cartersville, GABuilt 1968 · S/N 15068926 N23398Murillo Anthony · Davis, CABuilt 1968 · S/N 15068928 N23421High Exposure Inc · Wilmington, DEBuilt 1968 · S/N 15068938 N23422Air Logistics Group LLC · Winston Salem, NCS/N 15068939 N23435Depinet Thomas E · Mount Gilead, OHS/N 15068944 N23437603 Flight LLC · Nashua, NHBuilt 1968 · S/N 15068945 N23440American Sky Aviation LLC · Anna, TXBuilt 1968 · S/N 15068947 N23443Henson Joseph A · Jasper, ALBuilt 1968 · S/N 15068949 N23444Garrett Scott E DBA · Owensville, INBuilt 1968 · S/N 15068950 N23453Harrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 15068957 N23458Blue Skies Aircraft LLC · Kalispell, MTBuilt 1968 · S/N 15068961 N23460Clark Johnathan W · Coventry, CTBuilt 1968 · S/N 15068963 N23461Egipciaco Jeffrey · Hampstead, NCBuilt 1968 · S/N 15068964 N23469N23469 LLC · Rehoboth Beach, DEBuilt 1968 · S/N 15068970 N23473G Force Advantage LLC · Lewes, DEBuilt 1968 · S/N 15068973 N23476Horizon Flight Center LLC · Chesapeake, VABuilt 1968 · S/N 15068976 N23486Hite Michael B · Martinsburg, WVBuilt 1968 · S/N 15068983 N23489Knebel Chris DBA · Boston, VABuilt 1968 · S/N 15068985 N23491Mcintosh Dyllon J · Anchorage, AKBuilt 1968 · S/N 15068987 N23492Roller Michael J · Gassville, ARBuilt 1968 · S/N 15068988 N234RKShelton Raymond O · Jeanerette, LABuilt 1968 · S/N 15068893 N23500Windsense LLC · Charleston, SCS/N 15068992

Back to Cessna 150H