AD 90-04-06 R1

Registered aircraft · 68,377

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:90-04-06-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:90-04-06-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.

N44VVHampton Warrior II Inc · Shelter Island, NYBuilt 1980 · S/N 28-8116009N44VWVan Wagnen Brian J · Jackson, MIBuilt 1945 · S/N 1408N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909N44WCWhite Eagle Investments LLC · San Jose, CABuilt 1995 · S/N 20242N44WDDemray William S · Northville, MIBuilt 1969 · S/N 30-1860N44WERedman Harvey E · Lapeer, MIBuilt 1998 · S/N 001N44WKMaiden Robert M · Williamson, GABuilt 1983 · S/N 11144N44WLLitton Wade N · Townsend, MTBuilt 2026 · S/N 20510N44WMBloomfield Robert C · Anchorage, AKBuilt 1974 · S/N 18-7409095N44WPAnderson Stuart R Jr · Sahuarita, AZBuilt 2015 · S/N ES1N44WTMoore Arlon A · Newcastle, CABuilt 2002 · S/N 23178N44WZWild Blue Yonder LLC · Batavia, OHS/N 729N44XDDuffer David · Fallbrook, CABuilt 1999 · S/N 1054N44YGAppelt Jon A · Dayton, NVBuilt 2010 · S/N 21698N44YTJohs Robert W · Palacios, TXBuilt 2020 · S/N 2383N44YUDoane Mica S · Meno, OKBuilt 2011 · S/N 64N44YYYankee LLC · Kasilof, AKBuilt 1979 · S/N 18-7909069N44ZCMarker Michael M Jr · Los Lunas, NMBuilt 1985 · S/N 4N44ZWTurner Robert H · San Diego, CABuilt 1977 · S/N 322-77N4500RWork Edward · Sneads Ferry, NCBuilt 1965 · S/N 28-21199N4500WMagalsky Jacob J · Wilsall, MTBuilt 1980 · S/N 18-8009019N4500ZBielefeld James L · Kenai, AKBuilt 1960 · S/N 22-8000N45018Cook Randal J · Newland, NCBuilt 1941 · S/N 2744N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614N4501HBrown Kevin · San Dimas, CABuilt 1978 · S/N 24-0750N4501JBleem Steven L · Duncan, OKBuilt 1968 · S/N 28R-30355N4501RNess James H · Phoenix, AZBuilt 1965 · S/N 28-21200N4502ZBoyer Bruce A · Toledo, OHBuilt 1960 · S/N 22-8002N45035Knutson Family Limited Partnership 2 · Chetek, WIBuilt 1941 · S/N 4421N4503JSkykid Adventures LLC · Cedar Valley, UTBuilt 1968 · S/N 28R-30358N4503YSteppler Dean M · Culbertson, MTBuilt 1971 · S/N 18-8923N4504YCronin Monty A · Gettysburg, SDBuilt 1971 · S/N 18-8924N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810N4505RFayal Kenneth E Jr · Bend, ORS/N 28-21205N4505YGeneral Air Service LLC · Van Wert, OHBuilt 1971 · S/N 18-8925N45060Stone Eric · Cedarpines Park, CABuilt 1976 · S/N 177RG1091N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881N4506RCruz Roberto Jr · Douglasville, GABuilt 1965 · S/N 28-21206N4506TPettit Kenneth W · Madison, INBuilt 1972 · S/N 28-7225176N4506VRegistered aircraftBuilt 1979 · S/N 28-8090026N4507JSkvara Stanley Henry Jr · Parma, OHBuilt 1968 · S/N 28R-30363N4507NGarnet Aviation LLC · Fort Worth, TXBuilt 1979 · S/N 28-8090031N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032N4507RFly First LLC · West Memphis, ARBuilt 1979 · S/N 28R-7918246N4507TLoma Aviation LLC · San Diego, CABuilt 1972 · S/N 28-7205174N4507XVanny Ravy · Winchester, CABuilt 1976 · S/N 28-7625046N45086Dahl Ken L · Granite Falls, MNBuilt 1976 · S/N 177RG1092N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813N4508JWood Daniel W · Cottonwood Shores, TXBuilt 1968 · S/N 28R-30364
Back to AD 90-04-06 R1