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.

N52321Kowal Steven K · Annapolis, MDBuilt 1973 · S/N 18262526 N52322Flat Top Energy LLC · Ghent, WVBuilt 1973 · S/N 18262527 N52324Hailey Jeremy A · Burlington, WABuilt 1973 · S/N 18262528 N52328Ethridge Ed · Bigfork, MTBuilt 1973 · S/N 18262530 N52329Heber James A · Gansevoort, NYBuilt 1973 · S/N 18262531 N52330Morgan John E · Waverly, TNS/N 18262532 N52332Beta Fleet LLC · South Burlington, VTBuilt 1973 · S/N 18262534 N52334Cooper Edwin H Jr · Austin, TXBuilt 1973 · S/N 18262536 N52337Willson Collin R · Lake Saint Louis, MOBuilt 1973 · S/N 18262538 N52342Child Todd A · Salt Lake City, UTBuilt 1974 · S/N 18262542 N52349Center O Flying Club · Tumwater, WABuilt 1973 · S/N 18262545 N52366Stewart Motor Co LLC · Wichita, KSBuilt 1973 · S/N 18262554 N52368Cook Jacy L · Bozeman, MTBuilt 1973 · S/N 18262556 N52372Ratliff Huey C Jr · Homer, LABuilt 1973 · S/N 18262559 N52373Marine Resources Inc · Gilbert, AZBuilt 1973 · S/N 18262560 N52375Cattles Kenneth M · Lampasas, TXBuilt 1973 · S/N 18262561 N52376Stanley J James · Williamson, GABuilt 1973 · S/N 18262562 N52379International Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N 18262563 N52381Ifr Inc · Richmond, VABuilt 1973 · S/N 18262565 N52383Sugar Beach Investments LLC · Lillian, ALBuilt 1973 · S/N 18262566 N52389Levine Jeffrey L · Crescent City, FLBuilt 1973 · S/N 18262572 N52393Riverside County Sheriffs Department · Hemet, CABuilt 1973 · S/N 18262573 N52398Salzman Michael · Milford, NHBuilt 1973 · S/N 18262577 N523DWFlagstaff Airlines LLC · Flagstaff, AZS/N 18261639 N52400Bluestem Acquisitions LLC · Fort Worth, TXBuilt 1973 · S/N 18262578 N52402Sunny Aviation LLC · Kalispell, MTBuilt 1973 · S/N 18262580 N52405Dorward Alan C · Shreveport, LABuilt 1973 · S/N 18262583 N52406Prestige Aeronautics LLC · Haslett, MIFirst renewal noticeBuilt 1973 · S/N 18262584 N52409Cosner Dirk · Greeley, COBuilt 1973 · S/N 18262587 N52415Pryor Stanley C · Indianapolis, INBuilt 1973 · S/N 18262591 N52416Toepfer Stan L · Lanark, ILS/N 18262592 N52420Isaacs John S · Fruitland Park, FLBuilt 1973 · S/N 18262596 N52422Stevens Michael C · Kaysville, UTBuilt 1973 · S/N 18262597 N52430Beaudikofer Eric · El Centro, CABuilt 1973 · S/N 18262602 N52431Lippian James Michael · New Boston, TXBuilt 1973 · S/N 18262603 N52443182-52443 LLC · Queen Creek, AZBuilt 1973 · S/N 18262612 N52447Msc Services Inc · Hugo, OKS/N 18262614 N52448Haman Peter A · Douglas, WYBuilt 1973 · S/N 18262615 N52450Vandelay Investment Group LLC · Northbrook, ILBuilt 1973 · S/N 18262617 N52454Clemens Kayleen · Arnold, CABuilt 1973 · S/N 18262620 N52458Eightball Air LLC · Spokane, WAS/N 18262623 N52459Noonan Joseph E Jr · Northport, MEBuilt 1973 · S/N 18262624 N52466Stanley Louis J · Onaway, MIBuilt 1973 · S/N 18262629 N52487Johnson Thomas W · Westminster, MDBuilt 1973 · S/N 18262639 N52499Zu Fliegen LLC · Las Vegas, NVBuilt 1973 · S/N 18262649 N5249CDavis Douglas L DBA · Everson, WABuilt 1973 · S/N 18262642 N524EMD D Gross Aviation Ltd · Amherst, OHFirst renewal noticeBuilt 1973 · S/N 18262611 N52509Thibodeau Carl J · Conway, NHBuilt 1973 · S/N 18262652 N52527Klingaman Tim · Gilbert, AZS/N 18262658 N52534Dedon Mark F · Dublin, CABuilt 1973 · S/N 18262659

Back to Cessna 182P