AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636N3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIBuilt 1977 · S/N 310R0880N3640NShaikh Samir K · Schaumburg, ILS/N 680021N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253N3640UMarkle Raymond J · Madawaska, MEBuilt 1963 · S/N 18255040N3640XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 348N3640ZElliott Frank F · Mojave, CABuilt 1960 · S/N 22-7535N36411Runsick Michael C · Wynne, ARBuilt 1973 · S/N 273-73N36413Steward James D · Monument, COBuilt 1973 · S/N 109-73N36414Dewitt Elvin H · Santa Monica, CABuilt 1973 · S/N 390-73N36417Huber Weylin L · Aberdeen, SDBuilt 1973 · S/N 575-73N3641BUnity Aero Of Delaware LLC · Dover, DEBuilt 1980 · S/N 61P08148063424N3641CFeldmann D Joshua · Epworth, IABuilt 1978 · S/N R18200290N3641DAdkins Steven · Oriental, NCBuilt 1956 · S/N 35341N3641MSweet Water Air LLC · Kissimmee, FLBuilt 1978 · S/N 32-7840068N3641NVilliger Arnold H · Henry, ILBuilt 1967 · S/N 680022N3641RGeorge Walker Field Inc · Bedminster, NJBuilt 1969 · S/N 28-5737N3641SHolzsweig Leon G · Dallas, TXBuilt 1980 · S/N 61P08178063426N3641WMitchell Jeffrey Scott · Donalsonville, GABuilt 1966 · S/N 32-544N3641YVictoria Jet Aviation LLC · Victoria, TXBuilt 1980 · S/N 61P08218063430N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514N3642CMcmahan Bryan · Gakona, AKBuilt 1954 · S/N 31140N3642DCorre Training Industries Inc · Federal Way, WABuilt 1956 · S/N 35342N3642MCraig James P · Jacksonville, ARBuilt 1947 · S/N 12-2497N3642PSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1955 · S/N 22-3393N3642QPorte Elvis · Miami, FLS/N MB-262N3642UPm Barrett Aviation LLC · Tucson, AZBuilt 1963 · S/N 18255042N3642WMasia Matt D · Paso Robles, CABuilt 1966 · S/N 32-545N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73N36438Dorman Richard E · Mesa, WABuilt 1973 · S/N 577-73N3643BCoffelt Kelly L · Bend, ORBuilt 1956 · S/N 32347N3643DNevins Robert · North Palm Beach, FLBuilt 1981 · S/N 6008358161238N3643MKing Jay M · King Salmon, AKS/N 12-2496N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023N3643TBds Flyer LLC · Middletown, DEBuilt 1981 · S/N 6008998161255N3643UN3643u Aviation LLC · Denver, COBuilt 1963 · S/N 18255043N3643XBurbey Mark G · Racine, WIS/N 301N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663N3644PHanselmann Seth · Lincoln, VTFirst renewal noticeBuilt 1955 · S/N 22-3395N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742N3644ULawrence Carl E · Boulder, COBuilt 1963 · S/N 18255044N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516N3645UHusaim John Steven · Hohenwald, TNBuilt 1963 · S/N 18255045N3645WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-549N3645XAubrey James M · North Little Rock, ARBuilt 1968 · S/N 302N3646063nl LLC · Willmar, MNBuilt 1981 · S/N 62P09008165029N3646HAdams Toby R · Paris, TXBuilt 1980 · S/N 6008568161245N3646KParrish Doug · Monument, COBuilt 1981 · S/N 61P08578163453N3646PMr Group · Rapid City, SDS/N 6108598162155N3646UGarner Lynn · Preston, IDS/N 18255046
Back to AD 2007-04-19 R1