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.

N52808Thane Inc · Elkridge, MDBuilt 1974 · S/N 18262862 N52812Northern Air Inc · Bonners Ferry, IDBuilt 1974 · S/N 18262866 N52821Big Bird Aerial Photography LLC · Astoria, ORBuilt 1974 · S/N 18262871 N52829Western Heights LLC · Boise, IDBuilt 1974 · S/N 18262879 N52836Payne Thomas E · Old Forge, NYBuilt 1974 · S/N 18262885 N52852Hultin Ronald · Rosemount, MNBuilt 1974 · S/N 18262897 N52853Heintz David A · Culver, ORS/N 18262898 N52857Tdex Equipment · Abilene, TXBuilt 1974 · S/N 18262901 N52859Wehrs Aviation LLC · Johnsburg, ILBuilt 1974 · S/N 18262903 N52861Holst Thomas C · Pleasant Hope, MOBuilt 1974 · S/N 18262904 N52863Swodeck John · Gilbert, AZS/N 18262906 N52866Egan Bailey J · Forsyth, MTBuilt 1974 · S/N 18262909 N52873Pepper Daniel J · Henderson, TXBuilt 1974 · S/N 18262916 N52876Noteboom Mike · Orange City, IABuilt 1974 · S/N 18262918 N52880Matta Sam · Houston, TXBuilt 1974 · S/N 18262921 N52884Smith Eric Von Trustee · Vallejo, CAFirst renewal noticeBuilt 1974 · S/N 18262925 N52886Gilbert Jack M · Visalia, CABuilt 1974 · S/N 18262927 N52888Alphadelta Aviation LLC · East Windsor, CTS/N 18262928 N52895Marshall Brian L · Hays, KSS/N 18262933 N52899Kalogerson George G Trustee · Eden Prairie, MNBuilt 1974 · S/N 18262937 N52907Hatcher James A · Hilltop Lakes, TXBuilt 1974 · S/N 18262943 N52916Boston Center Flying Club Inc · Dracut, MABuilt 1974 · S/N 18262949 N52919Tucker Benny L · Thomaston, GABuilt 1974 · S/N 18262952 N52923Grinton Harry M · Arvada, COBuilt 1974 · S/N 18262955 N52940Schickner Michael J · Mesa, AZBuilt 1974 · S/N 18262964 N52942Origer Deborah F · Albany, ORS/N 18262966 N52957Koch Eric C · Charlotte, NCBuilt 1974 · S/N 18262973 N52959Triple T Metal Corp · Bryantsville, KYBuilt 1974 · S/N 18262975 N52963Union Movie Works LLC · Sacramento, CABuilt 1974 · S/N 18262976 N52981J-Bear Aviation LLC · Whitefish, MTBuilt 1974 · S/N 18262984 N52983Cabaud John P · Oroville, CABuilt 1974 · S/N 18262986 N52989Southwest Tailwinds LLC · Camarillo, CABuilt 1974 · S/N 18262989 N52992Registered aircraftBuilt 1974 · S/N 18262991 N52994Carpenter Michael · Hardin, MOBuilt 1974 · S/N 18262993 N52996Mcnab Michael J Trustee · Slayton, MNBuilt 1974 · S/N 18262994 N52997Plaugher Carl L · Cocoa Beach, FLBuilt 1974 · S/N 18262995 N52998Frauenhoff Frank W · Manhattan, NVBuilt 1974 · S/N 18262996 N52ENRefuge Properties LLC · Goshen, KYS/N 18263612 N534PCSutton Brad · Vallecito, CABuilt 1975 · S/N 18264394 N53EURegistered aircraftBuilt 1973 · S/N 18262276 N54TVAllen And Lambert Inc · Bolingbroke, GABuilt 1975 · S/N 18264264 N550CERobinson James K · Eagle, IDBuilt 1975 · S/N 18264074 N550JBBowley John P · Middletown, NYBuilt 1973 · S/N 18262671 N550NVHoffman Andrew Todd · Mound House, NVBuilt 1973 · S/N 18262017 N550PJPeterson Todd · El Dorado, KSBuilt 1973 · S/N 18262142 N550WPJacobs Justin · San Francisco, CABuilt 1976 · S/N 18265163 N551BGOne Bravo Gulf LLC · Lutz, FLBuilt 1973 · S/N 18262018 N554CTGeyer Martin J · Caro, MIBuilt 1975 · S/N 18263737 N555DJWeidner Robert R · Port Townsend, WABuilt 1973 · S/N 18262293 N555GHPeck Lowell B · Pasco, WABuilt 1975 · S/N 18264477

Back to Cessna 182P