OpenAirDocs.org
AD 80-01-06

Registered aircraft · 2,131

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-01-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-01-06')
  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.

N101ATZrelak Patrick DBA · Apple Valley, CABuilt 1977 · S/N 15280208N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243N104UCAspiring Aviators Aero Club · Winter Haven, FLS/N 15284673N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998N106UCInsuraclaim LLC · Boca Raton, FLBuilt 1981 · S/N 15285419N107RCHat Creek Construction & Development Inc · Glennville, GABuilt 1981 · S/N 172RG0807N107TSSmith Terry G · Liberty Twp, OHBuilt 1982 · S/N 172RG0907N108EAArellano Erick C · Brownsville, TXS/N 172RG0674N109CFMarigi William Kihara · Worcester, MABuilt 1978 · S/N 15282332N10VFAce Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282873N111HPFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1984 · S/N 172RG1153N111RKSan Carlos Flight Center Inc · San Carlos, CABuilt 1977 · S/N 15280874N112THHanson David J · Elgin, TXS/N 15280204N113FASale Reported · Dallas, TXSale reported, canceledBuilt 1981 · S/N 15285090N115CFFlying C Leasing · Wilmington, DES/N 15283557N115SSSoutheastern Oklahoma State University · Durant, OKBuilt 1979 · S/N 15283679N117PBLadue Scott B · Fate, TXBuilt 1981 · S/N 172RG0897N117RCMaresh Jeremiah · Redding, CAS/N 172RG0034N1196DAerobat Aoa LLC · Wilmington, DES/N A1520764N122CFSouthwest Aviation Specialties LLC · Tulsa, OKS/N 15282778N124RPPeroyea John L II · Midlothian, TXBuilt 1978 · S/N 15282139N1265PElder George · Perryville, MOS/N 15284992N127EDRussell Robert Q · Genoa City, WIBuilt 1980 · S/N 15284797N12EABrown Gary Ashton · Simpsonville, SCS/N 15279903N130CFFlying C Leasing Ltd · Wilmington, DEBuilt 1977 · S/N 15279509N131CFBurke Christopher L · Gordon, GABuilt 1978 · S/N 15282248N131VUMalisa Michael D · Goodyear, AZBuilt 1985 · S/N 172RG1191N135WAHardin Melissa K · Terrell, TXBuilt 1979 · S/N 15283655N13EAHood Norman R · Austin, TXBuilt 1977 · S/N 15279914N14SKHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283422N151VUVincennes University · Indianapolis, INBuilt 1980 · S/N 172RG0667N152APGood Life Aviation LLC · San Tan Valley, AZBuilt 1982 · S/N A1521015N152AWYouth Missions Aviation Academy Inc · Southlake, TXBuilt 1985 · S/N 15285977N152AZRegistration Pending · Long Beach, CARegistration pendingBuilt 1979 · S/N 15283886N152BBJensen Harold G · San Antonio, TXBuilt 1979 · S/N 15283831N152BJMissionaire LLC · Kennedy, NYBuilt 1982 · S/N 152-85670N152BMPluska Paul · Hansville, WABuilt 1978 · S/N A1520831N152BPBaker John A · Cape Coral, FLBuilt 1977 · S/N 15281066N152BUGreen Airport Development Corp · Kemah, TXBuilt 1983 · S/N 15285698N152CJFoss Fred C · Naperville, ILBuilt 1978 · S/N 15281682N152DMHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 15280302N152DXCastracane Mark A · Hattiesburg, MSBuilt 1984 · S/N 15285886N152DZPopovitch Michael P · Marina, CABuilt 1978 · S/N 15281491N152EF47 North Aviation LLC · Wenatchee, WABuilt 1979 · S/N 15283975N152ERAviat Aircraft Inc · Afton, WYBuilt 1978 · S/N 15282469N152FASomnium Volans LLC · Walton Hills, OHBuilt 1979 · S/N 15283937N152FCNygren Shad · Fallon, NVBuilt 1979 · S/N 15283642N152GBHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279546
Back to AD 80-01-06