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.

N5243RDraco Flight School Inc · Chino, CABuilt 1974 · S/N 17263457N5243WFalcon Air LLC · Casper, WYBuilt 1961 · S/N 28-284N5243XMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1969 · S/N 186N52440Hap'S Air Inc · Ames, IABuilt 1981 · S/N 17274523N52441Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274524N52443182-52443 LLC · Queen Creek, AZBuilt 1973 · S/N 18262612N52447Msc Services Inc · Hugo, OKS/N 18262614N52448Haman Peter A · Douglas, WYBuilt 1973 · S/N 18262615N5244DMalnarick Kyce S · Anchorage, AKBuilt 1958 · S/N 50142N5244EOpal Aviation LLC · Athens, GABuilt 1978 · S/N 17271794N5244GMcmahan William K · Sandy Valley, NVBuilt 1961 · S/N 310M0026N5244LGarman Daniel L · Burr Oak, KSBuilt 1968 · S/N 28-4539N5244NCongressional Flying Club Inc · Gaithersburg, MDBuilt 1980 · S/N 18267594N5244RClauson Ed P · Charlestown, RIBuilt 1974 · S/N 17263458N5244URoberts Todd · Friday Harbor, WABuilt 1964 · S/N 206-0244N5244VKnucklehead Aviation LLC · Cedar City, UTBuilt 1980 · S/N 172RG0481N5244XFrantz William T · Wasilla, AKBuilt 1969 · S/N 184N5244ZRobinson Levi B · Anchorage, AKBuilt 1981 · S/N U20606085N52450Vandelay Investment Group LLC · Northbrook, ILBuilt 1973 · S/N 18262617N52454Clemens Kayleen · Arnold, CABuilt 1973 · S/N 18262620N52458Eightball Air LLC · Spokane, WAS/N 18262623N52459Noonan Joseph E Jr · Northport, MEBuilt 1973 · S/N 18262624N5245CN5245c LLC · Sequim, WABuilt 1978 · S/N 310R1523N5245JNuzzo Christian Larsen · Locust Grove, GABuilt 1976 · S/N 310R0811N5245KPerun Av LLC · Cliffside Park, NJBuilt 1980 · S/N 17274029N5245VMarianas Air Transfer Inc · Saipan, MPBuilt 1980 · S/N 172RG0482N5245WSwartzfager Lee C · Corry, PABuilt 1962 · S/N 28-287N5245XPlane Fixer LLC · Ball Ground, GABuilt 1968 · S/N 18258856N52466Stanley Louis J · Onaway, MIBuilt 1973 · S/N 18262629N5246LSmithson Thomas E · Franklin, TNBuilt 1967 · S/N 28-4541N5246MFlorida Aviation Career Training Inc · Saint Augustine, FLBuilt 1978 · S/N MC-564N5246PYoyodyne Group Inc · Wilmington, DES/N 24-277N5246UMize Helicipter LLC · Edmond, OKS/N 172RG0298N5246WScovil Jarin K · Laramie, WYS/N 28-288N52473American Patrols Inc · Midland, TXBuilt 1980 · S/N 17274535N5247RHarbour Aviation LLC · Weatherford, TXBuilt 1974 · S/N 17263461N5247TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225371N52483Walsh Air Enterprises · Sugar Land, TXBuilt 1980 · S/N 17274537N52487Johnson Thomas W · Westminster, MDBuilt 1973 · S/N 18262639N5248EColorado Skywagon LLC · Kiowa, COBuilt 1959 · S/N 50548N5248PKnox Edward R · Gulfport, MSBuilt 1958 · S/N 24-279N5248TDopfel Sierra M · Udall, KSBuilt 1972 · S/N 28-7225372N5248UStephens Robert Z · Missoula, MTBuilt 1980 · S/N 172RG0300N5248WBalfa Joshua · Lumberton, TXBuilt 1962 · S/N 28-290N52499Zu Fliegen LLC · Las Vegas, NVBuilt 1973 · S/N 18262649N5249ABrentco Aerial Patrol Inc · Canton, OHBuilt 1985 · S/N P21000840N5249CDavis Douglas L DBA · Everson, WABuilt 1973 · S/N 18262642N5249DQuicksilver Skycraft LLC · Langley, WAS/N 17272470N5249EAlexandria Aviation Inc · Alexandria, MNBuilt 1978 · S/N 17271797N5249JWhitgo LLC · Lucas, TXBuilt 1980 · S/N 17273744
Back to AD 2007-04-19 R1