Skip to content

Registered aircraft · 1,637

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.

N101ATZrelak Patrick DBA · Apple Valley, CABuilt 1977 · S/N 15280208 N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832 N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996 N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243 N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673 N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998 N106UCInsuraclaim LLC · Boca Raton, FLBuilt 1981 · S/N 15285419 N109CFMarigi William Kihara · Worcester, MABuilt 1978 · S/N 15282332 N10VFAce Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282873 N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874 N112THHanson David J · Elgin, TXS/N 15280204 N113FASale Reported · Dallas, TXSale reported, canceledBuilt 1981 · S/N 15285090 N115CFFlying C Leasing · Wilmington, DES/N 15283557 N115SSSoutheastern Oklahoma State University · Durant, OKBuilt 1979 · S/N 15283679 N1196DAerobat Aoa LLC · Wilmington, DES/N A1520764 N122CFSouthwest Aviation Specialties LLC · Tulsa, OKS/N 15282778 N124RPPeroyea John L II · Midlothian, TXBuilt 1978 · S/N 15282139 N1265PElder George · Perryville, MOS/N 15284992 N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797 N12EABrown Gary Ashton · Simpsonville, SCS/N 15279903 N130CFFlying C Leasing Ltd · Wilmington, DEBuilt 1977 · S/N 15279509 N131CFBurke Christopher L · Gordon, GABuilt 1978 · S/N 15282248 N135WAHardin Melissa K · Terrell, TXBuilt 1979 · S/N 15283655 N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914 N14SKHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283422 N152AWYouth Missions Aviation Academy Inc · Southlake, TXBuilt 1985 · S/N 15285977 N152AZRegistration Pending · Long Beach, CARegistration pendingBuilt 1979 · S/N 15283886 N152BBJensen Harold G · San Antonio, TXBuilt 1979 · S/N 15283831 N152BJMissionaire LLC · Kennedy, NYBuilt 1982 · S/N 152-85670 N152BPBaker John A · Cape Coral, FLBuilt 1977 · S/N 15281066 N152BUGreen Airport Development Corp · Kemah, TXBuilt 1983 · S/N 15285698 N152CJFoss Fred C · Naperville, ILBuilt 1978 · S/N 15281682 N152DMHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 15280302 N152DXCastracane Mark A · Hattiesburg, MSBuilt 1984 · S/N 15285886 N152DZPopovitch Michael P · Marina, CABuilt 1978 · S/N 15281491 N152EF47 North Aviation LLC · Wenatchee, WABuilt 1979 · S/N 15283975 N152ERAviat Aircraft Inc · Afton, WYBuilt 1978 · S/N 15282469 N152FASomnium Volans LLC · Walton Hills, OHBuilt 1979 · S/N 15283937 N152FCNygren Shad · Fallon, NVBuilt 1979 · S/N 15283642 N152GBHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279546 N152GFBright Shaji · Martinez, GABuilt 1978 · S/N 15282309 N152GSBitondo Steven S · Mamaroneck, NYBuilt 1978 · S/N 15282256 N152GTHansen Nelse · Lawrenceville, GABuilt 1977 · S/N 15279503 N152HFBaier Dale Edwin · Colleyville, TXBuilt 1977 · S/N 15279555 N152HRWarner James A · Watertown, NYBuilt 1980 · S/N 15284697 N152HWWuertz Errol Gene Jr · Mcpherson, KSBuilt 1978 · S/N 15281995 N152JPatterson Casey Paul · Kinston, ALBuilt 1979 · S/N 15283162 N152JLCivil Air Support LLC · Phoenix, AZBuilt 1978 · S/N 15281834 N152LBurdick Rich · Montrose, COBuilt 1979 · S/N 15283964 N152LEBirjandi Akbar · Westlake Village, CABuilt 1978 · S/N 15282306

Back to Cessna 152