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.

N1933MShepherd Matthew R · Bloomington, INBuilt 1976 · S/N 18264487 N1934MKornetzke Jeffrey A · Lake Mills, WIBuilt 1976 · S/N 18264488 N1936MScott George M · Reno, NVS/N 18264489 N1937MPoultry Not Beef LLC · Chancellor, ALBuilt 1976 · S/N 18264490 N1941MEf Air Holdings LLC · Midkiff, TXBuilt 1976 · S/N 18264493 N1942MRegistration Pending · Linn, TXRegistration pendingBuilt 1976 · S/N 18264494 N1945MOchs Roland P · Brighton, COBuilt 1976 · S/N 18264496 N1954MBecker Verne L · Manhattan Beach, CABuilt 1976 · S/N 18264500 N1957MStewart Alexander E · Medina, WABuilt 1976 · S/N 18264502 N1960MJereb Robert M · Rohnert Park, CABuilt 1976 · S/N 18264505 N1961MSwindle Malorie J · Birmingham, ALBuilt 1976 · S/N 18264506 N1973JMormile Jason B · Fultonville, NYBuilt 1973 · S/N 18262469 N1976MJackling Eric S · Rochester, NYS/N 182-64331 N1978TSilva Daniel · Mapleton, ILBuilt 1974 · S/N 18263132 N1981MOlson Robert Carter · Gold Canyon, AZBuilt 1976 · S/N 18264510 N1985MSokalsky Leigh Anne · Monee, ILBuilt 1976 · S/N 18264514 N1988MFacility Concepts LLC · Jackson, MSBuilt 1976 · S/N 18264517 N1989MCrosswind Aviation LLC · Friendswood, TXBuilt 1976 · S/N 18264518 N198JMBlazey James R · Palmyra, NYBuilt 1973 · S/N 18262235 N1991PMyron Holdings LLC · Puyallup, WAS/N 18263326 N1993MPoskey Charles E · Alabaster, ALBuilt 1976 · S/N 18264522 N1994MAgile Aviation LLC · Rotonda West, FLBuilt 1976 · S/N 18264523 N1996MHarrison Dan H · Englewood, FLBuilt 1976 · S/N 18264525 N1998MExecutive Aviation LLC · Peoria, AZBuilt 1976 · S/N 18264527 N1999MSoltis Andrew · Salem, OHFirst renewal noticeBuilt 1976 · S/N 18264528 N19GCKobaly Jason D · Yucca Valley, CABuilt 1972 · S/N 18261280 N1QPN667sr LLC · Richmond, KYBuilt 1972 · S/N 18261605 N201SHRyan L Phillips Inc · Campobello, SCBuilt 1973 · S/N 18262073 N204JWN204jw LLC · Fort Worth, TXBuilt 1976 · S/N 18265167 N20706Ahf Investments LLC · Ruston, LABuilt 1972 · S/N 18261142 N20708Viersen Leonard J Trustee · Glennallen, AKBuilt 1972 · S/N 18261144 N20709Superior Fresh LLC · Idaho Falls, IDBuilt 1972 · S/N 18261145 N20713Spradling Tommy G Jr · Campbell, TXBuilt 1972 · S/N 18261148 N20725Smith James M · Burbank, WABuilt 1972 · S/N 18261157 N20730Tantiyatyanon Preeda · Flagstaff, AZBuilt 1972 · S/N 18261162 N20735Porter H Tom · Columbia, MSBuilt 1972 · S/N 18261165 N20738Acquafly Creation LLC · Apopka, FLS/N 18261168 N20740Registered aircraftBuilt 1972 · S/N 18261170 N20743Eagles Flight LLC · Grove, OKBuilt 1972 · S/N 18261172 N20751Donovan John A W · Wellesley, MABuilt 1972 · S/N 18261178 N20755Sale Reported · Wichita, KSSale reportedBuilt 1972 · S/N 18261181 N20757Johnson Mark B · Etna, CABuilt 1972 · S/N 18261183 N20761Hearty Pet Inc · Maugansville, MDS/N 18261184 N20767Cook Mike R · Rye, COBuilt 1972 · S/N 18261186 N2076920769 LLC · Elbert, COBuilt 1972 · S/N 18261188 N20771Cussen George J · Mount Prospect, ILBuilt 1972 · S/N 18261190 N20774S & J LLC · Albany, MOBuilt 1972 · S/N 18261192 N20777Marthew Aviation LLC · Rochester, MIS/N 18261195 N20785Villa Axel · Orlanda, FLS/N 18261201 N20791L A M Capital Management LLC · Sheridan, WYBuilt 1972 · S/N 18261207

Back to Cessna 182P