OpenAirDocs.org
AD 79-21-09 R1

Registered aircraft · 154

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:79-21-09-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-21-09-R1')
  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.

N6176VAeronaut Aviation LLC · East Quogue, NYBuilt 1977 · S/N 829N6177V51 Uniform LLC · Spofford, NHBuilt 1977 · S/N 830N6183VCripe Rodney J · Middlebury, INBuilt 1977 · S/N 836N6185VBig Bang Airlines LLC · Ithaca, NYBuilt 1977 · S/N 838N6187VBudreau Austin S · Angola, INBuilt 1977 · S/N 840N6188VShinstrom David C · Eastsound, WABuilt 1977 · S/N 841N6189VMark & David LLC · Coldwater, MSBuilt 1977 · S/N 842N6196VRegistered aircraftS/N 849N6207VFenwick Stuart J · Coolin, IDS/N 854N6213VBeard John H · Lakeville, MNS/N 856N6244VColberg Sigurd E · Palmer, AKBuilt 1977 · S/N 859N628JSRegistration Pending · Macon, MSRegistration pendingS/N 793N67CMillspaugh Edward J · Center Barnstead, NHBuilt 1980 · S/N 1051N69LARegistration Pending · Las Vegas, NVRegistration pendingBuilt 1980 · S/N 1035N69VYAhlhorn Travis · New Braunfels, TXBuilt 1977 · S/N 832N6KJXta-Sea LLC · Gross Point Woods, MIS/N 844N717HCLeading Edge Leasing LLC · Wilmington, DEBuilt 1983 · S/N 1085N717HQArwen Evenstar LLC · Wilmington, DEBuilt 1981 · S/N 1059N72GVHawkes Alexander · Mooresburg, TNS/N 1044N747CBAom Aircraft LLC · Wilmington, DES/N 754N75UTSkyward Solutions Inc · Lewes, DEBuilt 1976 · S/N 762N768ELRohrbaugh Mark II · Raymond, MES/N 768N7HPClausen Todd · Vancouver, WABuilt 1980 · S/N 1036N8000WMoore George D Jr · Waldo, FLBuilt 1979 · S/N 990N8001AFandler Frederick E · Denton, TXBuilt 1979 · S/N 991N80026Baldwin Philip · Spokane, WAS/N 1007N8002MJasper Aviation Inc · Jasper, ALS/N 1001N8003HShafer James H · Port Orchard, WAS/N 1012N8003QHocking Earl · La Salle, ILS/N 1013N80042Ippisch Steven B · Soldotna, AKS/N 1030N8004BInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 1022N8004COrban Howard L · Rockford, MIBuilt 1980 · S/N 1023N8004GAmazon Aero Corp · Wilmington, DES/N 1025N8004RArbogast Matthew G · Ooltewah, TNS/N 1028N8005BAmphibians Plus LLC · Bartow, FLS/N 1033N8006EHot700 LLC · Boca Raton, FLS/N 1042N8009XFioravanti Barbara K · Mirror Lake, NHS/N 1054N8011XFly & Sea Inc · Pittsburgh, PABuilt 1981 · S/N 1062N80122Amphibians Plus LLC · Bartow, FLBuilt 1981 · S/N 1069N8012ANiehaus James O · Erie, COS/N 1065N8012DWhitney Steven G · Glenview, ILS/N 1066N8014FRoebuck Craig M · Otter Creek, MEBuilt 1982 · S/N 1078N820ANMazeika Aaron P · Dayt Bch Sh, FLBuilt 1979 · S/N 967N8543CMr B Aviation LLC · Sag Harbor, NYBuilt 1984 · S/N 1103N8543HPorterfield Brian B · Wasilla, AKBuilt 1984 · S/N 1105N8563YJohnson Richard · Fort Lauderdale, FLBuilt 1985 · S/N 1110N8BZLongoria Carlos Federico · Austin, TXBuilt 1976 · S/N 761N91LMansberger Aircraft Inc · Fort Worth, TXBuilt 1978 · S/N 920N948PWEagles Soar LLC · Lewes, DEBuilt 1979 · S/N 948N956SLLittle James S · Douglass, TXBuilt 1977 · S/N 846
Back to AD 79-21-09 R1