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.

N735DXSantamaria Joseph J · Hebron, NHBuilt 1977 · S/N 18265352 N735DYRegistered aircraftBuilt 1977 · S/N 18265353 N735EBSpohn Craig C · Shreveport, LABuilt 1977 · S/N 18265356 N735ECTrillia Roy Alan John Trustee · Berkeley, CABuilt 1977 · S/N 18265357 N735EENewbold Business Advisory LLC · Manassas Park, VABuilt 1977 · S/N 18265359 N735EHLaw Offices Of Jorge Luis Flores LLC · Covington, GABuilt 1977 · S/N 18265362 N735EJTrashman Aviation LLC · Durant, OKBuilt 1977 · S/N 18265363 N735ELBrown Aaron P · Joliet, ILBuilt 1977 · S/N 18265365 N735EMKing Jeffrey W · North Myrtle Beach, SCBuilt 1977 · S/N 18265366 N735EUErnst Albert S III · Buda, TXBuilt 1977 · S/N 18265373 N735EYSchneider J David · Montrose, COFirst renewal noticeBuilt 1977 · S/N 18265377 N735FCIndian Bayou Aviation LLC · Indianola, MSBuilt 1977 · S/N 18265381 N735FDLee Ronald E · Tualatin, ORBuilt 1977 · S/N 18265382 N735FEZoeller Kenneth Harold · Billings, MTBuilt 1977 · S/N 18265383 N735FKUmeno Hiroo · Seattle, WABuilt 1977 · S/N 18265388 N735FNHughes James E Jr · Jasper, TXBuilt 1977 · S/N 18265390 N735FTBlakeslee David Shawn · Sierra Madre, CABuilt 1977 · S/N 18265395 N735FXD Plummer Enterprises Inc · Factoryville, PABuilt 1977 · S/N 18265399 N735FYHartman Raymond · Danville, ARBuilt 1977 · S/N 18265400 N735FZEchohealth Imaging LLC · Anacortes, WABuilt 1977 · S/N 18265401 N735GBCowboy Sky LLC · Enterprise, MSBuilt 1977 · S/N 18265403 N735GCOlgar Flying LLC · Ithaca, NYBuilt 1977 · S/N 18265404 N735GDHester Neal E · Visalia, CABuilt 1977 · S/N 18265405 N735GKD L A Aircraft Inc · Wilmington, DEBuilt 1977 · S/N 18265411 N735GPBarnette Don A · Jonesboro, GAS/N 18265415 N735GQ735gq LLC · Corvallis, ORBuilt 1977 · S/N 18265416 N735GSPointcloud Aviation Inc · Plymouth, MNBuilt 1977 · S/N 18265418 N735GTTuomi Jane M · Anchorage, AKS/N 18265419 N735GUSenseney Ricky · Fishers, INBuilt 1977 · S/N 18265420 N735GVC B Air LLC · Franklin, TNS/N 18265421 N735GWCec Joseph D · Riverside, CAS/N 18265422 N735GXAga Aviation LLC · Mcallen, TXS/N 18265423 N735HDFoster Jason Donald · Willis, TXBuilt 1977 · S/N 18265429 N735HFHatch David P · Tok, AKBuilt 1977 · S/N 18265431 N735HGSouthern Oaks Farm LLC · Lewes, DEBuilt 1977 · S/N 18265432 N735HHOptic Air LLC · St Maurice, IAS/N 18265433 N735HJLuckie Jessie O · Ashland, KSBuilt 1977 · S/N 18265434 N735HMFabco Enterprises LLC · Grand Rapids, MIBuilt 1977 · S/N 18265437 N735HRSkylane Inc · Idaho Falls, IDBuilt 1977 · S/N 18265441 N735HSDls Aviation LLC · Missoula, MTBuilt 1977 · S/N 18265442 N735HTKimmel Michelle D · Cushing, OKBuilt 1977 · S/N 18265443 N735HWLeask John A · Deerfield, OHBuilt 1977 · S/N 18265446 N735HXKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 18265447 N735JUS Aero Club LLC · Orlando, FLBuilt 1977 · S/N 18265812 N735JAMallery John · Olean, NYBuilt 1977 · S/N 18265450 N735JCAvfun LLC · San Antonio, TXBuilt 1977 · S/N 18265452 N735JDVulcan Engineering · Bloomington, CABuilt 1977 · S/N 18265453 N735JFSchneider Ruth Ellen · Durango, COBuilt 1977 · S/N 18265455 N735JGBritt David J · Somerset, KYS/N 18265456 N735JKMashman Edward A · Los Angeles, CABuilt 1977 · S/N 18265459

Back to Cessna 182Q