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.

N517SHHelme Stanley B · Lodi, CABuilt 2003 · S/N 70624N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318N517VBBoudro Vernon G · Greenview, CABuilt 2008 · S/N 70216N517WCFreedom Wings LLC · Parker, COBuilt 1993 · S/N 1809065N517WDAmundson Lee R · Chatfield, MNBuilt 2021 · S/N 02210164N51807Maniscalco Peter · Germansville, PABuilt 1942 · S/N 75-2529N5180BRoberts Toney K · Batesville, MSS/N 6-6833N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397N5180XSouthern Sky Holdings LLC · Macon, GABuilt 1969 · S/N 190N5180ZScheer Paul G · Portland, ORBuilt 1961 · S/N 22-8846N51810Jones David L · Powderly, TXS/N 224N5181HRegistered aircraftBuilt 1975 · S/N 17265363N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035N5181TSchmetter Kenneth E · Needville, TXBuilt 1967 · S/N 508N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216N5181XKummer Nicolas · Wenatchee, WABuilt 1969 · S/N 191N5182ERegistered aircraftBuilt 1978 · S/N 17271756N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469N5182SFoster Tyler R · Levelland, TXS/N 28-7105036N5183HLlewellyn John M · Grangeville, IDBuilt 1949 · S/N 14-501N5183LWolstenholme Robert F · Line Lexington, PABuilt 1984 · S/N 0001N5183MGc Aviation Services 1 LLC · Miamisburg, OHBuilt 1978 · S/N ME-13N5183PAig Aeronautics LLC · Guaynabo, PRBuilt 1981 · S/N 15284890N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037N5183TMinier Tryg · Corralitos, CABuilt 1967 · S/N 16N5183XStory James W · Byhalia, MSBuilt 1969 · S/N 170N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N51846Magnum Aviation LLC · Goff, KSBuilt 1978 · S/N 78-015N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184HReynolds Michael A · Fairbanks, AKBuilt 1949 · S/N 14-502N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472N5184S1st Cooling Inc · Rockwall, TXBuilt 1970 · S/N 28-7105038N5184XComstock Derrick B · Salol, MNBuilt 1969 · S/N 173N5184ZCox Ronnie · Whitesburg, GABuilt 1961 · S/N 22-8851N51850Hendrickson Flying Service Inc · Rochelle, ILBuilt 1978 · S/N 78-018N51851Brothers Aviation LLC · Black Rock, ARBuilt 1978 · S/N 78-019N51859Barr Andrew B · Beulah, MSBuilt 1979 · S/N 79-026N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N5185QRegistered aircraftBuilt 1989 · S/N 300N5185TRomano Serge · Beaverton, ORBuilt 1967 · S/N 15N5185ZTroy Michael J · Albion, NYS/N 22-8852N51863Green Wendell L · Argyle, TXBuilt 1980 · S/N 46N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362N5186HPope Brian B · Coalgate, OKBuilt 1975 · S/N 17265365N5186LKlippel Charlie L · Huntington Beach, CABuilt 1980 · S/N 15284276N5186WQuick Janice L · Wrightwood, CABuilt 1961 · S/N 28-221
Back to AD 90-04-06 R1