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.

N580MStockman Harold O · Elko, NVBuilt 1998 · S/N 24580N580NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496257N580SKEary Enterprises LLC · Peoria, AZBuilt 2006 · S/N S-0013N580SUMetro Aviation Inc · Shreveport, LABuilt 1981 · S/N 172RG0877N580UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020165N58105Mooney Skies Unlimited LLC · Merritt Island, FLS/N 24-3059N5810HInternational Air Services Inc Trustee · Carson City, NVBuilt 1949 · S/N 16-426N5810USmith Herbert E · Rochelle, ILBuilt 1969 · S/N 28-26638N5810VTuskegee Airmen National Historical Museum · Detroit, MIBuilt 1944 · S/N 75-5893N58115Morten Jesse L · Larimore, NDBuilt 1973 · S/N 25117N5811EMoss Jessee C · Ardmore, OKBuilt 1978 · S/N 17271941N5811QElliott Areospace LLC · Kalispell, MTBuilt 1965 · S/N 771N58120Air Giblinski LLC · Sedgwick, KSS/N 24-1647N58124North-Air Helicopters Inc · Frankfort, NYBuilt 1973 · S/N 25124N5812LLindly Lowell J · Nashville, ARBuilt 1971 · S/N AA5-0012N5812USeymour Lori L · Woodstock, GABuilt 1969 · S/N 28-26641N5813HLoewen Walter · Kodiak, AKBuilt 1949 · S/N 16-430N5813QWalmsley Stephen R Jr · Menifee, CABuilt 1965 · S/N 772N5813UStackhouse Thomas G · Bethlehem, PAS/N 24-1649N5813VRose William A · Chesapeake, VABuilt 1977 · S/N 28-7790502N5813WStothers Brian · Lake Havasu City, AZBuilt 1964 · S/N 28-1954N5813ZSmith Gregory E · White Lake, MIBuilt 1963 · S/N 22-9670N5814DMessinger Donald C · Wasilla, AKBuilt 1956 · S/N 22-4489N5814HPapich William · Boston, NYBuilt 1949 · S/N 16-431N5814UAnderson Timothy B · Cold Spring, KYBuilt 1970 · S/N 28-26644N5814WP&K Enterprises LLC · Madison Heights, VABuilt 1964 · S/N 28-1965N58153Marsan Steve R · Sisters, ORS/N 24-1580N58159Mcclure Jeffrey S · Loomis, CAS/N 24-1650N5815HZernechel Craig A · Rockford, ILBuilt 1949 · S/N 16-432N5815LFidler Richard · San Francisco, CABuilt 1972 · S/N AA5-015N5815SClear Aire LLC · Las Vegas, NVBuilt 1986 · S/N 24-1577N5815UMiller William W Jr · Henderson, NVBuilt 1969 · S/N 28-26643N5815VDebs Raymond E · Boise, IDBuilt 1941 · S/N 75-7616N58160Brb Flight Services LLC · Laguna Beach, CABuilt 1974 · S/N 740324N58162Link Stanley C · Theodosia, MOS/N 24-1587N5816DTurner Robert E · Talladega, ALBuilt 1956 · S/N 22-4491N5816LSparrowhawk Aviation LLC · Moraine, OHFirst renewal noticeBuilt 1972 · S/N AA5-0016N5816QHigh Flying Vision LLC · Clarksdale, MSBuilt 1965 · S/N 3117N5816UHarsimran Singh · Las Vegas, NVBuilt 1970 · S/N 28-26645N5816ZPerdew Paul T · Mcfarland, WIBuilt 1963 · S/N 22-9674N58174Castle Farms Inc · Sunnyside, WAS/N 480685N5817FWicker John E · Lexington, NCBuilt 1976 · S/N 28-7790136N5817HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1949 · S/N 16-434N5817TSnow Robert I · New Caney, TXBuilt 1988 · S/N 24-1654N5817WDow Jeff W · Port Hadlock, WABuilt 1964 · S/N 28-1988N5817ZLamb Matthew P · Edmond, OKBuilt 1963 · S/N 22-9644N5818HSlatter Lowell J · Buhl, IDBuilt 1949 · S/N 16-447N5819DMiceli Michael J · Frewsburg, NYBuilt 1956 · S/N 22-4494N5819HGaniere Constance L · Kemp, TXFirst renewal noticeBuilt 1949 · S/N 16-435N5819LLandauer Jacob · Gainesville, FLBuilt 1972 · S/N AA5-0219
Back to AD 90-04-06 R1