Skip to content

Registered aircraft · 48

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

N152APGood Life Aviation LLC · San Tan Valley, AZBuilt 1982 · S/N A1521015 N152BMPluska Paul · Hansville, WABuilt 1978 · S/N A1520831 N152XTDiaz Alcides L · Archbald, PABuilt 1979 · S/N A1520907 N159SKSeacrest Enterprises LLC · Asheville, NCBuilt 1979 · S/N A1520900 N333Grullon Guarocuya · Van Buren Twp, MIBuilt 1980 · S/N A1520963 N333NEEarle Norman R · Hastings, FLS/N A1520852 N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909 N4596AMlfco LLC · Wilmington, DEBuilt 1978 · S/N A1520837 N4669AWolstenholme Ralph E · Westfield, PABuilt 1979 · S/N A1520860 N4718AQuinby Gary D Trustee · Ardmore, OKBuilt 1979 · S/N A1520880 N4734ANewman Macy M · Plano, TXBuilt 1979 · S/N A1520885 N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891 N4799ANew England Aircraft Detailing LLC · Webster, MABuilt 1979 · S/N A1520893 N4950AShaffer Barbara J · Franklin, KYS/N A1520910 N4951A152 University LLC · Blacksburg, VABuilt 1979 · S/N A1520911 N4957APea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N A1520915 N4958ALamonica Patrick H · San Diego, CABuilt 1979 · S/N A1520916 N7140BEstep James B · Chillicothe, OHBuilt 1977 · S/N A1520740 N7187CWoldt Wayne E · Raymond, NEBuilt 1973 · S/N 681 N7305LHill Stephen C · Fort Collins, COBuilt 1978 · S/N A1520780 N7321BAdvanced Aviation School LLC · Venice, FLBuilt 1977 · S/N A1520743 N7330BLogan Richard M · St Louis Park, MNBuilt 1977 · S/N A1520746 N7336BWild Robert · Woodbury, NJBuilt 1977 · S/N A1520750 N7340BThaut Lance A · Fullerton, CABuilt 1977 · S/N A1520752 N7340LAzure 01 LLC · Canton, NYBuilt 1978 · S/N A1520792 N7348BPatry Andrew · El Mirage, AZBuilt 1977 · S/N A1520753 N7349BWilliams Kiplin S · Midland, NCBuilt 1977 · S/N A1520754 N7380LAsiatico Ruperto M · Virginia Beach, VABuilt 1978 · S/N A1520799 N7391LAbdulshafi Ahmed Jason · Oxnard, CABuilt 1978 · S/N A1520808 N7392LKnowles Charles M Jr · Chapmanville, WVS/N A1520809 N7395LCatherines Aviation Services LLC · Sewanee, TNBuilt 1978 · S/N A1520812 N7397BAerolina Inc · Hendersonville, NCBuilt 1977 · S/N A1520766 N7398LNelson Gregory J · Newcastle, CABuilt 1978 · S/N A1520815 N7553BTri Star Aviation Inc · Nashua, NHBuilt 1977 · S/N A1520767 N7558LBahinting Dan Brian M · Rosamond, CABuilt 1978 · S/N A1520819 N758YSFly Sky Ads LLC · Manalapan, NJBuilt 1982 · S/N A1521017 N758YTMountain Air Flying LLC · Brigham City, UTBuilt 1982 · S/N A1521018 N7607LMeyer Maria S · New Fairfield, CTBuilt 1978 · S/N A1520825 N7610AScrap Materials Inc · Huntington, ARS/N A1520738 N761ESCronsell Kenneth L · Hampshire, ILBuilt 1980 · S/N A1520947 N761FGWilliams Glenn D · Columbus, GABuilt 1980 · S/N A1520949 N761GGChocks Away Aviaton LLC · Redmond, ORBuilt 1980 · S/N A1520951 N761UAFirst Wings LLC · Sayre, PAS/N A1520986 N761YEUnique Educational Experiences Inc · Signal Hill, CABuilt 1981 · S/N A1520997 N762JSSayers James B · Edison, OHBuilt 1981 · S/N A1520970 N8138LN8138l LLC · Metairie, LABuilt 1978 · S/N A1520828 N83TMCimino Joseph Michael · Decatur, ALBuilt 1977 · S/N A1520748 N980NOneill Aviation LLC · Lake Wales, FLS/N A1520814

Back to Cessna A152