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.

N7125LCulbertson Lloyd K · Phillipsburg, KSBuilt 1973 · S/N AA5-0425N7125QPiedmont Flight Inc · Winston Salem, NCBuilt 1972 · S/N 17260425N7125UTakacs Robert S · Oxford, CTBuilt 1964 · S/N 364N7125VSutphen James A · Henderson, TXBuilt 1974 · S/N 22-0054N7125WRavelli Sidney · Salem, OHBuilt 1962 · S/N 28-922N71266Kuhtenia David G · Galena, OHBuilt 2016 · S/N 60355N7126DKintner Daniel S · Conyers, GABuilt 1957 · S/N 22-4986N7126GHenry Rolla G Jr · Saint Charles, MOBuilt 1966 · S/N 30-1001N7126KWaller David · Carthage, MOBuilt 1958 · S/N 18-344N7126RLeonard Justin P · Charleston, SCBuilt 1966 · S/N 28-21827N7127BGeorge William A · Denton, TXBuilt 1956 · S/N 22-4345N7127RGreen William A · Memphis, TNS/N 28-21828N7127YSpencer Avionics Inc · Spencer, IABuilt 1963 · S/N 30-148N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828N7128LUrocopters Inc · Lancaster, CAS/N AA5-0428N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428N7128URegistration Pending · Billings, MTRegistration pending, canceledBuilt 1992 · S/N 889N7128VLinville Aero LLC · Chapel Hill, NCBuilt 1974 · S/N 22-0057N7128WVan Curen Mary Ann · Owasso, OKS/N 28-925N7128YAir Mods And Repair Corp · Robbinsville, NJBuilt 1963 · S/N 30-149N7129DBusse Charles U · Cary, ILBuilt 1959 · S/N 22-4989N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129PBachand Cade C · Dickinson, NDBuilt 1960 · S/N 24-2292N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N7129RLinn Stephen K · Evergreen, COBuilt 1966 · S/N 28-21830N7129YButner Gary W · Yuba City, CABuilt 1963 · S/N 30-151N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712DMFox Dennis C · Oklahoma City, OKBuilt 2012 · S/N 72775N712DTBrown Charles A · Boise, IDS/N 575N712GWArmstrong Michael L · Bend, ORFirst renewal noticeBuilt 2010 · S/N 107MN712JGBirdsong Brad · Lubbock, TXS/N 872-320-669-SFBN712LDia Development LLC · Mesa, AZBuilt 1956 · S/N 18-5082N712MDMosley Daniel J · Jackson, MSBuilt 2015 · S/N 01N712PJason Schwitters Farm Inc · Clara City, MNBuilt 1947 · S/N 12-1670N712RFix Wing LLC · Fort Lauderdale, FLBuilt 1967 · S/N 18-8556N712RFFleming Ray J · Duson, LABuilt 2004 · S/N 70070N712SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8640N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676N712WHWhiskey Hotel LLC · Marengo, ILBuilt 1991 · S/N 1712N7130Lash Alvin C · Redmond, ORBuilt 2007 · S/N 72113N7130DSorenson Gregory John · Hope, AKBuilt 1957 · S/N 22-4992N7130VKerkstra Hilary · Portage, MIBuilt 1974 · S/N 22-0059N7130WRoye Bart L · Slaton, TXBuilt 1962 · S/N 28-928N7131BWeisel Jeffrey W · Prescott, AZBuilt 1956 · S/N 22-4350N7131LMalof Matthew P · Falls Church, VABuilt 1974 · S/N AA5-0631N7131YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-153N7132BConsolini Joseph · Driggs, IDBuilt 1964 · S/N 22-4351N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N7132RGreydanus Samuel E · Holland, MIBuilt 1966 · S/N 28-21833
Back to AD 90-04-06 R1