OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N30DDRegenstein Jacob · San Francisco, CABuilt 1992 · S/N 20349N30DSSaver Matthew S · Lebanon, TNBuilt 2003 · S/N 81482N30DWHeffernan Michael James · Wellesley, MABuilt 1971 · S/N 28R-7135229N30ECVogt Timothy J · Houston, TXBuilt 1997 · S/N 1284N30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1963 · S/N 30-59N30FHBaldwin Jonathan B · East Boothbay, MEBuilt 1973 · S/N 34-7350203N30FKN30fk LLC · Chesterfield, MOBuilt 2012 · S/N 73331N30FMM20j LLC · Niceville, FLBuilt 1997 · S/N 24-3410N30GSClausen Robert G · Argyle, MNBuilt 1973 · S/N 17261470N30GWAnderson Brett J · Groton, SDBuilt 1954 · S/N 18-3939N30HUDukes William R · Tallulah, LABuilt 1998 · S/N 1406N30JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17268043N30JBBalbierer John M · Columbus, MSBuilt 1998 · S/N 23892N30JGAdamson Don · Lonoke, ARBuilt 1976 · S/N 1369N30JKThompson Troy L · Amarillo, TXS/N 732N30JNDls Holdings Inc · Lewes, DEBuilt 1957 · S/N 30-1423N30JPPhilpott Connor J Ryan · Newbury Park, CABuilt 1977 · S/N 1-0052N30JSFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1977 · S/N 28R-7837100N30JTMatthews William P · Blacksburg, VAS/N 80903N30JVJasper Aviation Inc · Jasper, ALBuilt 1964 · S/N TD-597N30JXOptimal Aviation Services LLC · Visalia, CABuilt 1964 · S/N 30-539N30KWWeeks Kermit A · Polk City, FLBuilt 1974 · S/N 003N30LAerojet Services Inc · Poplar Grove, ILBuilt 1942 · S/N 3772N30LERollins Robert · Gadsden, ALBuilt 1971 · S/N 28R-7235018N30LVNorth Arkansas Aviation LLC · Paragould, ARS/N 28-7916098N30MEKustudich Tim · Holland, MIBuilt 1985 · S/N MICKELSON-0001N30NAPerryman Ronald William · Purmela, TXS/N AA1C-0010N30NKOlah Michael J · Mazomanie, WIBuilt 1984 · S/N 162N30NWCenterline Aerospace Inc · Clermont, FLFirst renewal noticeBuilt 1964 · S/N 30-312N30PSweet Kim G · Rogers, ARS/N F8027N30PMReimer Lynn C · Sioux Falls, SDS/N 2N30PSRosendahl Greg C · Boulder, COS/N K081N30RHHalye Roger J · Port Orange, FLBuilt 1977 · S/N 17269998N30RVHarris John W · Lewisville, TXBuilt 1999 · S/N 2025N30SBFlare LLC · Chattanooga, TNBuilt 2004 · S/N 955-2004N30SHMedic Choppers LLC · Springdale, ARBuilt 1966 · S/N 30-1262N30TJFiskars Equipment Co · Saint Joseph, MIBuilt 1965 · S/N 30-762N30TSAv8rs LLC · Gig Harbor, WABuilt 1994 · S/N 156N30UAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1955 · S/N 247N30VBukolsky Ivan · Silt, COBuilt 1955 · S/N 12-333N30VFStang Philip · Setauket, NYBuilt 2005 · S/N 1B2004N30WHAcme Aerosports Inc · Huntsville, ALBuilt 1977 · S/N 997-77N30WPBanquer Douglas J · Denham Springs, LABuilt 1983 · S/N 1236N30WWHr Air LLC · Lakeland, FLBuilt 1994 · S/N 1N30WYFlexible Flyer LLC · Cody, WYBuilt 2007 · S/N 2420N30XTBurnette Ric A · Sebastian, FLBuilt 1967 · S/N 30-1644N30YDAndre John D · Chesapeake, VABuilt 1998 · S/N 23555N30ZAJohn Caleb Aviation · Lafayette, LABuilt 1992 · S/N 200030N3100Meyer Matthew D · Redding, CABuilt 1967 · S/N 491421N31006Tanner Paul L · Savoy, TXBuilt 1978 · S/N 489-H
Back to AD 90-04-06 R1