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.

N4860WHershorin Mason P · Pembroke Pines, FLBuilt 1966 · S/N CE-119N4860YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4662N48616Hall Stanley C · Sequim, WABuilt 1943 · S/N 78N4861ARubbert Randy C · Reynolds, NDBuilt 1956 · S/N 22-4020N4861DThornquist Robert K · Anchorage, AKBuilt 1958 · S/N 34961N4861GFlying Colors Airparts Inc · Leesburg, FLBuilt 1979 · S/N 17273408N4861LPodolinski Frank · Greensburg, PABuilt 1967 · S/N 28-4213N4861SMidwest Airmotive Inc · Mount Sterling, KYBuilt 1979 · S/N R18201439N4861UGoodmanagement Healthcare Inc · Chandler, AZS/N 205-0561N4861VRegistered aircraftBuilt 1980 · S/N 172RG0403N4862DHixson G C · Readyville, TNBuilt 1958 · S/N 34962N4862EGyuro Stephen Douglas Trustee · Benton, KSBuilt 1982 · S/N 18268279N4862JWicker Gregory B · Irmo, SCBuilt 1966 · S/N TC-1024N4862LGunter Gordon D · Green River, WYBuilt 1968 · S/N 28-4216N4862UDodson International Parts Inc · Rantoul, KSBuilt 1964 · S/N 205-0562N4862YKohler Richard L · Moriarty, NMBuilt 1968 · S/N 25-4665N4863ARud Alexandra E · Clara City, MNBuilt 1956 · S/N 22-4022N4863BBeach Travis W · Bishop, CABuilt 1955 · S/N 35163N4863LZimmerman Marlin · Muscoda, WIBuilt 1967 · S/N 28-4217N4863QKlamar Spraying Inc · Gatzke, MNBuilt 1976 · S/N 18802599TN4863SHogs LLC · Georgetown, SCBuilt 1970 · S/N 32-1290N4863TM & M Light Transportation Co Inc · Duluth, MNBuilt 1981 · S/N R18201778N4863USpot Aviation LLC · Nevada, IABuilt 1964 · S/N 205-0563N4864DChiota Aviation LLC · Waco, TXFirst renewal noticeBuilt 1979 · S/N 17272377N4864FFreely James John · Marshall, VAS/N 28-7790069N4864GLazy Eights Holdings LLC · Greenwood, INBuilt 1979 · S/N 17273411N4864LRegistration Pending · Boone, NCRegistration pendingBuilt 1967 · S/N 28-4218N4864YWilliams R E · Fort Walton Beach, FLBuilt 1980 · S/N 21064021N48652Lorenz John C · Edgewood, NMBuilt 1943 · S/N 135N4865DBlack Hound Aviation LLC · Austin, TXS/N 17273904N4865PThundersky Farms Inc · Helena, MTBuilt 1978 · S/N P21000124N4865SBowman Steven R · Manteo, NCBuilt 1970 · S/N 32-1296N4865UMajor Richard L Jr DBA · Hickman, KYBuilt 1964 · S/N 205-0565N4865VWoltjer Richard J · Pennock, MNBuilt 1968 · S/N 30110N4866DBetts Thomas L · Fort Collins, COBuilt 1958 · S/N 34966N4866HHolbrook Andrew L · Burgaw, NCBuilt 2013 · S/N 80157N4866KNavion Aviation LLC · Littleton, COS/N NAV-4-1866N4867DFlynn Brian · Auburndale, FLBuilt 1979 · S/N 17272378N4867JNational Aero Services LLC · Helena, MTBuilt 1966 · S/N TE-276N4867KMark Thomas Productions LLC · Ketchum, IDBuilt 1979 · S/N P21000349N4867L23 Right LLC · Kalispell, MTBuilt 1967 · S/N 28-4221N4867UFeyen Richard F · Kaukauna, WIBuilt 1964 · S/N 205-0567N4868AKlokner James B · Madison, WIBuilt 1978 · S/N 310R1393N4868EVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17271671N4868JFoster Milton F · Dawson, GABuilt 1966 · S/N TE-277N4868LWinningham Matthew P · Prattville, ALBuilt 1968 · S/N 28-5123N4868NWisner David · East Hampton, NYBuilt 1979 · S/N 18267425N4869ANevill Bernard L · Clare, MIBuilt 1956 · S/N 22-4029N4869CBerry Matthew G · Creedmoor, NCBuilt 1975 · S/N 18502637N4869DCutler Donald R · Bolivar, MOBuilt 1958 · S/N 34969
Back to AD 2007-04-19 R1