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.

N4706LKings Heir Inc · Kent, WABuilt 1967 · S/N 28-4026N4706QRegistration Pending · Polson, MTRegistration pendingBuilt 1966 · S/N 185-1160N4706SGreat Lakes Aviation LLC · Burtchville, MIBuilt 1979 · S/N R18201392N4707ASherman Aviation Inc · Redmond, ORBuilt 1956 · S/N 18-4924N4707BOlathe Spray Service Inc · Olathe, COBuilt 1955 · S/N 31605N4707CSmith James A · Lyle, WABuilt 1955 · S/N 22-3291N4707JBeck Joseph P II · Pollock, LABuilt 1966 · S/N MA-147N4707KKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1975 · S/N 18263706N4707SBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18201393N4707TVan Ausdall John C · Spring Branch, TXBuilt 1981 · S/N R18201739N4707UZero Seven Uniform LLC · Palmer, AKBuilt 1964 · S/N 18051407N4707YWengair LLC · Powell, WYBuilt 1967 · S/N 25-4439N47084Tabor Peter C · Durango, COBuilt 1975 · S/N 18263783N4708AFranz Stanley · Yakima, WABuilt 1956 · S/N 18-4926N4708LAlexander Nicholas R · Oak Hill, OHBuilt 1967 · S/N 28-4027N4708NSkylane LLC · Billings, MTBuilt 1979 · S/N 18267298N4708QCole Brent R · Anchorage, AKBuilt 1966 · S/N 185-1162N4708VSpears Patricia C · Longmont, COBuilt 1953 · S/N 30165N47093Skipper Consulting LLC · Athens, ALBuilt 1942 · S/N 2N4709DMagalsky Jacob J · Wilsall, MTBuilt 1957 · S/N 34809N4709KAlexander & Knizley Inc DBA · Mobile, ALBuilt 1975 · S/N 18263708N4709LJohannsen Michael R · Allen, TXBuilt 1967 · S/N 28-4028N4709RG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0013N4709SMolinar Antonio L · El Paso, TXBuilt 1979 · S/N R18201395N470AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843742N470AKAkima Logistics Services LLC · Usaf Academy, COBuilt 2018 · S/N CC18-0089N470AWWhitesell Paul Trustee · Plano, TXBuilt 1966 · S/N D-8073N470BCCorvus Flight LLC · Salinas, CABuilt 1977 · S/N 414-0918N470CBoese Jon D · Holloway, MNBuilt 1997 · S/N 2448N470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PABuilt 2005 · S/N 1611N470CMWooden Wings LLC · Prescott, AZBuilt 1959 · S/N 4107N470EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11599N470FLBaker Brian K · Dayton, OHBuilt 1971 · S/N 28-7125271N470FSCustom Air International LLC · Homestead, FLBuilt 1973 · S/N 17262011N470HPBloch Christopher P · Grand Rapids, MIBuilt 1998 · S/N 2004N470JCCox Patrick A · Torrance, CABuilt 1972 · S/N 18052265N470JKHill Kenneth R · Port Charlotte, FLBuilt 2006 · S/N 90310N470JSShort Jeffery G · Cottonwood, CABuilt 1980 · S/N 470N470KCColeman Keith T · Mukilteo, WAS/N 1491N470KMAv Chase LLC · Kirtland, OHBuilt 1998 · S/N 17280614N470MAKek Companies Inc · Portland, ORBuilt 2000 · S/N 2105N470MJLong John D · Lake Wylie, SCBuilt 2011 · S/N 81562N470PGreentree Aviation LLC · Sewell, NJBuilt 2004 · S/N 18281290N470RPDaytona Aircraft Services Inc · Daytona Beach, FLBuilt 2014 · S/N 72675N470RVFlyguys Aviation LLC · Bay City, MIBuilt 1968 · S/N 18259314N470SHopkins William C · Reno, NVS/N 3080N470UNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 17280415N470XSale Reported · Priest River, IDSale reportedBuilt 1965 · S/N 18256370N4710LStuhmer Samuel K · Central City, NEBuilt 1967 · S/N 28-4029N4710QNeitz Frank A · Bethel, AKBuilt 1966 · S/N 185-1164
Back to AD 2007-04-19 R1