Skip to content

Registered aircraft · 1,565

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

N4716NHolcombe Aaron L · Jay, OKBuilt 1979 · S/N 18267305 N4717NHaagenson Jeffrey M · Portland, ORS/N 18267306 N4718NL3harris Technologies Flight Capital LLC · Greenville, TXBuilt 1979 · S/N 18267307 N4721NRegistered aircraftBuilt 1979 · S/N 18267310 N4723NNorth Central Aircraft LLC · Blaine, MNBuilt 1979 · S/N 18267312 N4727NState Of Wisconsin · Madison, WIBuilt 1979 · S/N 18267316 N4728NSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18267317 N4730NThompson Sheila M · Natchez, MSBuilt 1979 · S/N 18267319 N4733N4733n LLC · Elberon, NJBuilt 1979 · S/N 18267322 N4734NWood Daniel Matthew · Yelm, WABuilt 1979 · S/N 18267323 N4735NAnderson Wood Products LLC · Ellington, MOS/N 18267324 N4736NHalter Irving L Jr · Philadelphia, PABuilt 1980 · S/N 18267315 N4740NGtz No 1 LLC · Kalispell, MTBuilt 1979 · S/N 18267329 N4741NCimmaron Flying Inc · Colorado Springs, COBuilt 1979 · S/N 18267330 N4742NRegistration Pending · Wilmington, DERegistration pendingBuilt 1979 · S/N 18267331 N4743NGallagher Jeff · Rio Oso, CABuilt 1979 · S/N 18267332 N4745NHowze William Scott · Robstown, TXBuilt 1979 · S/N 18267333 N4746NDenham Stacy L · Chehalis, WABuilt 1979 · S/N 18267334 N4750NSaez Brian · Gilboa, NYBuilt 1979 · S/N 18267337 N4753NSimmons Todd B · Cowley, WYBuilt 1979 · S/N 18267340 N4754NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267341 N4757NTwin Falls Fliers Inc · Twin Falls, IDBuilt 1979 · S/N 18267343 N4759NMitchell Robert L · Presque Isle, MIBuilt 1980 · S/N 18267344 N4763NBathum Dale · Ketchum, IDS/N 18267346 N4764NWhite Robert H · Eagar, AZBuilt 1979 · S/N 18267347 N4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORBuilt 1979 · S/N 18267350 N4768NTreadwell Dennis A · El Cajon, CABuilt 1979 · S/N 18267351 N4769NTurner Luke · Mineral Wells, TXBuilt 1979 · S/N 18267352 N4775NTennessee Metals Recycling LLC · Murray, KYBuilt 1979 · S/N 18267358 N4776NRegistration Pending · Ceiba, PRRegistration pendingBuilt 1979 · S/N 18267359 N4777NRosario Edwin A · Pine Island, NYBuilt 1979 · S/N 18267360 N4781NRobwin Air LLC · Lutz, FLBuilt 1979 · S/N 18267364 N4783NPlane Sense LLC · Oregon City, ORBuilt 1979 · S/N 18267366 N4785NHolden Engineering Inc · Oviedo, FLBuilt 1979 · S/N 18267368 N4789NRegistered aircraftBuilt 1980 · S/N 18267409 N4796NCessna N4796n LLC · Shreveport, LABuilt 1979 · S/N 18267374 N4799NLobb David C · Fort Myers, FLBuilt 1979 · S/N 18267377 N47GEMcbride Michael J · Loxley, ALBuilt 1978 · S/N 18266717 N47TZZilka Timothy R · Alpine, WYBuilt 1977 · S/N 18265448 N4801NBrentco Aerial Patrol Inc · Canton, OHBuilt 1979 · S/N 18267378 N4802NCentral Oregon Aviation Partners LLC · Bend, ORBuilt 1979 · S/N 18267379 N4804NMueller Scott · Somis, CABuilt 1979 · S/N 18267380 N4806NGibson Ronald M · Laurel Hill, NCBuilt 1979 · S/N 18267382 N4809NNewland John G · Eagle, IDBuilt 1979 · S/N 18267383 N4811NMiller Edwin C · Proctor, WVS/N 18267385 N4819NSilva Robert · Davis, CABuilt 1979 · S/N 18267391 N4822NBalinski Stephen W · Lusby, MDBuilt 1979 · S/N 18267394 N4825NBlue 79 LLC · Loogootee, INBuilt 1979 · S/N 18267397 N4829NKcj Fly LLC · Fuquay Varina, NCBuilt 1979 · S/N 18267399 N4830NSimansky Daniel W Trustee · Van Nuys, CABuilt 1979 · S/N 18267400

Back to Cessna 182Q