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.

N4852PGreenwood Auto LLC · Itta Bena, MSBuilt 1980 · S/N 15284831 N48549Davies Richard E · Sequim, WABuilt 1979 · S/N 15283349 N48568Spartan Education LLC · Tulsa, OKBuilt 1979 · S/N 15283350 N48581Luis Enrique Quintana · Miami, FLS/N 15283351 N48590Heavy Metal Air LLC · Farmingdale, NYS/N 15280920 N4860BWeaver Dianna K · Benton, LABuilt 1979 · S/N 15283678 N48610Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1977 · S/N 15280922 N48637K S Aviation · Atwater, CABuilt 1977 · S/N 15280924 N48650Herion Chris W · Williamsburg, VABuilt 1977 · S/N 15280926 N48690Chamberlin William C · Williamsburg, MIBuilt 1977 · S/N 15280929 N4869LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284237 N48708Greene Caleb M · Laverne, CAS/N 15280934 N4870PWooten Gerry W · Edmond, OKBuilt 1980 · S/N 15284834 N48710Conner Michael James · Scotts Valley, CABuilt 1977 · S/N 15280935 N48725Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280937 N4874BKoppelmann Kevin J · Cuba, MOS/N 15283687 N48751Tyau Jon S · Las Vegas, NVBuilt 1977 · S/N 15280951 N48753Harford Flying Club Inc · Kingsville, MDBuilt 1977 · S/N 15280952 N48757Stone To Glass LLC · Lake Worth, FLBuilt 1977 · S/N 15280956 N48762Carter Flygare Inc · Sacramento, CABuilt 1979 · S/N 15283369 N48763Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280959 N48764Cohen Harold L · Pensacola, FLBuilt 1979 · S/N 15283370 N48768General Aviation Support Corp · Rosamond, CAS/N 15283371 N48779Bryan Robert G · Orland Park, ILBuilt 1977 · S/N 15280963 N48787Angel Aviation Inc · Peoria, AZBuilt 1977 · S/N 15280967 N4878BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283689 N48810Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280976 N48816Feuerlein Maximilian · Tampa, FLBuilt 1977 · S/N 15280979 N48823Silver Express Co DBA · Miami, FLS/N 15280984 N48836Messenger Air Ltd · Madrid, IABuilt 1977 · S/N 15280993 N48842Elon Aviation LLC · Burlington, NCBuilt 1977 · S/N 15280997 N48848Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281000 N48856Neumeister Brian K · Edwardsville, ILBuilt 1977 · S/N 15281005 N48868Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281013 N48878Kilo Lima Investments LLC · Huntington Beach, CABuilt 1978 · S/N 15281023 N48879Matson Dean R · Spring, TXBuilt 1977 · S/N 15281024 N48883Fly Kful Inc · Fullerton, CABuilt 1977 · S/N 15281026 N48887Fault Line Flyers · Leander, TXBuilt 1977 · S/N 15281030 N4888HRudisel Timothy A · Kewadin, MIBuilt 1979 · S/N 15283999 N4888LAshton Marc J · Petaluma, CABuilt 1980 · S/N 15284239 N48895Mulvania Rodney A · Linn, MOBuilt 1977 · S/N 15281037 N488EKingdom Air Corps · Sutton, AKBuilt 1977 · S/N 15279654 N48900Smtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 15283387 N48918Aero Fliers LLC · Kalispell, MTS/N 15283389 N48924Cobb Susie O · Fayetteville, TNBuilt 1977 · S/N 15281051 N48932Poursartip Nader · Hayward, CABuilt 1977 · S/N 15281056 N48935Chambers Wyatt Allan · Ludlow, MABuilt 1977 · S/N 15281059 N48938International Flying Club Inc · Winfield, ILBuilt 1977 · S/N 15281060 N48941Somboonsap Patanapong · Fort Lauderdale, FLBuilt 1977 · S/N 15281062 N48961Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281074

Back to Cessna 152