Skip to content

Registered aircraft · 1,636

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

N49249Krawczak Kyle C · Littleton, COBuilt 1979 · S/N 15283442 N49260Youth Aeronautics Education Foundation · Mattaponi, VABuilt 1977 · S/N 15281209 N49261Salem Oregon Flight Training LLC · Salem, ORBuilt 1977 · S/N 15281210 N49268Fox John E · Boonville, CABuilt 1977 · S/N 15281213 N49276Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281217 N4927BAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283709 N49285Fullerton Airport Pilot Association · Fullerton, CABuilt 1979 · S/N 15283445 N49288Wisconsin Aviation Inc · Watertown, WIBuilt 1977 · S/N 15281226 N4928BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283710 N49292Johnson Scott W · Saline, MIS/N 15283446 N4930BSkyranch Knoxville Youth Inc · Knoxville, TNS/N 15283712 N4931BWojtowicz Tomasz · Bronx, NYBuilt 1979 · S/N 15283713 N49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448 N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449 N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849 N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033 N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240 N49417Rich John E · Dunnellon, FLS/N 15281248 N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250 N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254 N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255 N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036 N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262 N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458 N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267 N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268 N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245 N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274 N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281 N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287 N49470Stidsen Carlton A · Tolland, CTS/N 15281293 N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294 N49516Bresson Flying Service Inc · Compton, ILBuilt 1979 · S/N 15283467 N4951BTaylor Randall G · Pottstown, PAFirst renewal noticeBuilt 1979 · S/N 15283719 N4951HUS Flight Academy International Inc DBA · Post, TXBuilt 1979 · S/N 15284044 N49527B&S Aviation LLC · Sylvania, OHBuilt 1979 · S/N 15283469 N4952BC & T Aviation Holdings Inc · Mckinney, TXBuilt 1979 · S/N 15283720 N4953BTfa Holding Corp · Daytona Beach, FLS/N 15283721 N4954HVega Jaime D · Garland, TXS/N 15284045 N49551Wahl Dale H · Watertown, WIBuilt 1979 · S/N 15283474 N49572Karnik Brandon S · Buffalo Lake, MNBuilt 1979 · S/N 15283476 N4962BUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1979 · S/N 15283726 N4962HKelly William W · Springfield, ORBuilt 1979 · S/N 15284047 N4962LCypret Phillip B · Sacramento, CABuilt 1980 · S/N 15284246 N49649C & T Aviation Holdings Inc · Mckinney, TXBuilt 1979 · S/N 15283488 N4964PGregory Kristen · Vallejo, CABuilt 1981 · S/N 15284862 N49654Herman Brian · Clarksdale, AZBuilt 1979 · S/N 15283491 N4967BUniv Of Illinois Bd Of Trustees · Savoy, ILBuilt 1979 · S/N 15283730 N49681Sunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 15283495 N4968PDuncan Arnold A · Bozeman, MTBuilt 1981 · S/N 15284863

Back to Cessna 152