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.

N36601Frett Dennis R · Windsor, MOBuilt 1978 · S/N 28-7816671N36602B2 W Corporation · Winona, MNBuilt 1978 · S/N 28-7816672N36603J&J Holdings Of Pella LLC · Pella, IABuilt 1978 · S/N 28-7816673N3660NJinnette Michael E · Lafayette, COS/N 12-1909N3660RBackcountry Wings LLC · Gig Harbor, WABuilt 1970 · S/N 28-5764N3661Mckenna Kent T · Torrance, CAFirst renewal noticeBuilt 1969 · S/N 070N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286N3661ARegistered aircraftBuilt 1954 · S/N 22-1921N3661LAccomazzo Mark E · Charlotte, NCBuilt 1978 · S/N 0816N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129N3661PBradham David T · Kenai, AKBuilt 1955 · S/N 22-3412N3661QLong Nathan J · Huntsburg, OHS/N MA-251N36622Jenkins Lawrence P · Deming, NMS/N C1091TAN36626Farrier John M · Tillamook, ORBuilt 1973 · S/N 411-74N36628Quale David R · Cottage Grove, WIBuilt 1973 · S/N 113-73N3662MKerzen Properties LLC · Fayetteville, ARBuilt 1947 · S/N 12-2613N3662NLarsen Kevin L · Firth, IDBuilt 1947 · S/N 12-1913N3662RBevard Thomas E · Montross, VABuilt 1969 · S/N 28-5766N3662WRocket Three LLC · Sheridan, WYBuilt 2023 · S/N 3662N3662ZDaniel Dario M · Charlotte, NCBuilt 1960 · S/N 22-7560N3663Carter Jay M · Mountain Home, ARBuilt 2017 · S/N C75-10112N3664ARegistration Pending · Taylorsville, KYRegistration pendingBuilt 1954 · S/N 22-1924N3664QDiana Scott J · Wallingford, CTBuilt 1967 · S/N MA-249N3664XLurie Steven C · Delta, ALBuilt 1968 · S/N 314N3665ADaffron Rodney · Ragland, ALBuilt 1954 · S/N 22-1925N3665LBeranek John W · Cascade, IABuilt 1978 · S/N 0817N3665MErnie Hall Aviation Museum Inc · Warren, OHBuilt 1947 · S/N 12-2530N3665NElt Aviation Inc · Peewee Valley, KYBuilt 1967 · S/N 680029N3665PHarness Jesse J · Peoria, AZS/N 18-4621N3665RDomke Kenneth M · Soldotna, AKBuilt 1954 · S/N 18-4112N3666KVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 22356N3666MLarson Samuel T · Anchorage, AKS/N 12-2616N3666QHighum Peter · Hernando Beach, FLBuilt 1967 · S/N MA-253N3666TOlson Ronnie E · Palmer, AKBuilt 1976 · S/N F-073N3666ZWedepohl Richard · Madison, WIBuilt 1960 · S/N 22-7564N36671Kiefer Karl F · The Woodlands, TXBuilt 1973 · S/N 002N36679Myers Maxwell D · Salt Lake City, UTBuilt 1941 · S/N L1411TAN3667NLong Michael C · Seattle, WABuilt 1946 · S/N 12-1918N3667PSlofly LLC · Red Lodge, MTBuilt 1955 · S/N 18-4624N3667QLife'S A Beech LLC · Wilmington, DEBuilt 1967 · S/N MA-269N3667RShamrock Aviation LLC · Broken Bow, NEBuilt 1970 · S/N 28-5771N3668KPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-23678N3668NConnors Sean P · Tampa, FLS/N 12-1919N3668QPaul B Meadowbrook Pc · Albany, ORFirst renewal noticeS/N MA-255N3668ZYork Matthew J · Waterloo, ILS/N 22-7566N36692Wade Mark C · Bonham, TXBuilt 1942 · S/N L17501N3669AFadenrecht Joe D · Cashmere, WABuilt 1953 · S/N 22-1928N3669MMitrzyk Gary L · Anchorage, AKBuilt 1947 · S/N 12-2621N3669NMcdonald Douglas E · Deering, NDBuilt 1947 · S/N 12-1920N3669QMarshall Jerry W · Centennial, COBuilt 1967 · S/N MA-256
Back to AD 90-04-06 R1