OpenAirDocs.org
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.

N37NERotor Technologies Inc · Nashua, NHBuilt 1994 · S/N 2450N37PVan De Pol John M · Amherst, TXS/N 21564N37PDDannenberg Paul A · Zeeland, MIBuilt 2001 · S/N 001N37PHHoye Michael B · Heath, TXBuilt 2000 · S/N 001N37PKThill James L · Leesburg, VABuilt 2001 · S/N 80890N37PRS & R Planes LLC · Tulsa, OKBuilt 1950 · S/N 18-90N37RGMindspring LLC · New Orleans, LAFirst renewal noticeBuilt 1991 · S/N 2099N37RHRegistered aircraftBuilt 1995 · S/N 22585N37RMMiller Richard N · Oxford, IABuilt 1978 · S/N 157N37RNCicero John · Concord, CABuilt 2014 · S/N 90207N37RPPearson Landon S · Madison, SDBuilt 1992 · S/N 811-6N37RWCitabria Aces LLC · Virginia Beach, VABuilt 1981 · S/N 969N37SACampbell John R Trustee · Saint Leo, FLBuilt 1972 · S/N 34-7250046N37SEPacific Northwest Aircraft Leasing Inc · Meridian, IDBuilt 2001 · S/N 17281035N37SFGo-Time Aviation LLC · Fort Worth, TXBuilt 2021 · S/N 3369N37SLRw Aviation LLC · Manitowish Waters, WIBuilt 1999 · S/N 2010N37SMWilliams Rick J · Cooperstown, NYBuilt 1992 · S/N 225N37TGSale Reported · Fort Payne, ALSale reported, pending cancellationBuilt 2014 · S/N 24870N37WBSterling Aviation Services Inc · Wilmington, NCBuilt 1955 · S/N CH-161N37WDRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 28-4550N37WPKinney Joseph B · Palmer, AKS/N 18-756N37WRStill Flying LLC · Carlisle, PABuilt 1975 · S/N 0721N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385N37WYWyo Ventures LLC · Buffalo, WYBuilt 2001 · S/N 2169N37XPLacey Scott M · Morris, ILBuilt 1976 · S/N K-037N37ZAMulder Theodor Louis · Overgaard, AZS/N 377AN37ZQMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 15282684N38000Gardner David J · Elk, WAS/N M-2297N3800FCampbell Joseph P · Vail, AZBuilt 1977 · S/N 0768N3801PKnutson Wayne R · Thompson, NDBuilt 1955 · S/N 22-3490N3801RFial Ronald A · Milwaukie, ORBuilt 1980 · S/N WA-191N3801TSeefeldt John V · Monticello, MNBuilt 1967 · S/N 28R-30115N38024Hancock Aviation LLC · Baton Rouge, LABuilt 1980 · S/N WA-197N38025Missaukee Aircraft Leasing LLC · Cadillac, MIBuilt 1980 · S/N WA-198N38026Terra Scott M · Vacaville, CABuilt 1980 · S/N WA-202N3802MClick Justin T · Hobart, INBuilt 1947 · S/N 12-2562N3802RN3802r LLC · New Ringgold, PABuilt 1970 · S/N 28-5830N3802ZRowland Keith E · Glennallen, AKBuilt 1960 · S/N 18-7535N3803ESorbi Aviation Inc · El Cajon, CABuilt 1981 · S/N ME-381N3803FPiercy Ronald S · Moses Lake, WABuilt 1977 · S/N 0771N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903N3803ZDeines Gerald G · Red Lodge, MTBuilt 1960 · S/N 18-7536N3804EGregory Michael P · Clayton, DEBuilt 2020 · S/N 5426N3804KWebster Max S · Dalton, PABuilt 1967 · S/N 28-23736N3804PMadsen Theodore W · Gillette, WYBuilt 1955 · S/N 22-3493N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904N3804TMarello Thomas J · Westminster, MDBuilt 1967 · S/N 28R-30118N3804ZCulbertson William Theodore · Helena, MTBuilt 1960 · S/N 18-7537N38054Burr William L Jr · Johns Creek, GAFirst renewal noticeBuilt 1980 · S/N WA-201N3805FSmith James E Trustee · Kalispell, MTBuilt 1977 · S/N 0773
Back to AD 90-04-06 R1