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.

N21358Paroulek Joseph F · Milton, DEBuilt 1972 · S/N 18261585 N21362Joyce James R · Bellevue, WABuilt 1972 · S/N 18261587 N21368Alta Air LLC · Boise, IDBuilt 1972 · S/N 18261589 N21370Garner Jan L · Fremont, OHBuilt 1972 · S/N 18261591 N21376Vodry John · Quilcene, WABuilt 1972 · S/N 18261596 N21393Dinelli Aviation LLC · Milton, DES/N 18261607 N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608 N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609 N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580 N21401Sterling Steven G · Richland, WABuilt 1972 · S/N 18261612 N21402Hester James Timothy · Fayetteville, GABuilt 1972 · S/N 18261613 N21404Usglap · Fort Morgan, COBuilt 1972 · S/N 18261615 N21405Brushwood John W · Coshocton, OHBuilt 1972 · S/N 18261616 N21414Flyboys Flying Club LLC · Pawleys Island, SCBuilt 1972 · S/N 18261624 N21416Campbell David Lloyd · Fredericksburg, TXBuilt 1972 · S/N 18261626 N21421Paul Janet K · Beaver Island, MIBuilt 1972 · S/N 18261630 N21445Woody Dwain F Trustee · Lubbock, TXBuilt 1972 · S/N 18261632 N21450Brant Gary E · Salisbury, PABuilt 1972 · S/N 18261637 N21453Super D Electric Inc · Coeur D Alene, IDBuilt 1972 · S/N 18261640 N21457Registration Pending · Deland, FLRegistration pendingBuilt 1973 · S/N 18261642 N21461Acme Aviation Inc · Lake Charles, LABuilt 1972 · S/N 18261645 N21462Fly Man LLC · Waxhaw, NCBuilt 1972 · S/N 18261646 N21465Clary Kenneth W Sr · Huntsville, TXS/N 18261648 N21472Registered aircraftBuilt 1972 · S/N 18261652 N21474Alexander David L · North Pole, AKBuilt 1972 · S/N 18261654 N21475Austin Police Dept · Pflugerville, TXBuilt 1972 · S/N 18261655 N21477Frizzell Richard W Jr · Blacksburg, VABuilt 1972 · S/N 18261657 N21487Millennial Flight LLC · Kalispell, MTS/N 18261663 N21488Mission Hardware LLC · Savannah, GABuilt 1973 · S/N 18261664 N21490Erff David F · Madison, CTBuilt 1973 · S/N 18261666 N21495Taylor Jason R · Moab, UTBuilt 1973 · S/N 18261670 N21501Kelch Wendell · Bethel, OHBuilt 1973 · S/N 18261675 N21508Newton Christian B · Redondo Beach, CABuilt 1973 · S/N 18261678 N21514Davis Ryan Edward · Bonney Lake, WABuilt 1973 · S/N 18261681 N21516Reinders Craig T · Hartland, WIBuilt 1973 · S/N 18261683 N21518Kilo Whiskey Aviation LLC · West Des Moines, IABuilt 1973 · S/N 18261685 N21520Schroeder Benjamin · Mcgregor, TXBuilt 1973 · S/N 18261686 N21529Tbm Aviation LLC · Wellington, ALBuilt 1973 · S/N 18261692 N21536Anb Aviation LLC · Bauxite, ARBuilt 1973 · S/N 18261698 N21542Bolea Air Inc · Morgan Hill, CABuilt 1973 · S/N 18261703 N21548Shaver Mike A · Roberts, WIBuilt 1973 · S/N 18261708 N21550Garber Glen D Jr · Perryton, TXBuilt 1973 · S/N 18261709 N21554Brosten Carl V · Monclova, OHS/N 18261712 N21557Rvi LLC · Boise, IDBuilt 1973 · S/N 18261714 N21562Blevins Michael W · Sayre, OKBuilt 1973 · S/N 18261715 N21566Brenner Gerald Benjamin · Oxford, MDBuilt 1973 · S/N 18261718 N21581Skyline Aviation Inc · Racine, WIFirst renewal noticeBuilt 1943 · S/N 18261729 N21587B & D Fuel Injection Service Inc · Rhoadesville, VABuilt 1973 · S/N 18261733 N21593Peyt Rentals LLC · Cobb, GABuilt 1973 · S/N 18261739 N21597Gsw Flyers LLC · Pittstown, NJBuilt 1973 · S/N 18261741

Back to Cessna 182P