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.

N2654ESch Aviation Inc Trustee · Sporle Kings LynnBuilt 1971 · S/N 39-93N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754N2654PSamson Mason H · Rives Junction, MIBuilt 1955 · S/N 22-2994N2654RFindarle John J · Midway, UTBuilt 1967 · S/N 18258354N2654YHolty Joseph G · Fairbanks, AKBuilt 1962 · S/N 18051154N2654ZAlbij3 LLC · Milton, FLBuilt 1977 · S/N 358-78N2655CSmith Lionel J · Ironton, MOBuilt 1955 · S/N 35055N2655GBeachy Benjamin D · Whittington, ILBuilt 1959 · S/N 51955N2655QRedmond Angela L · Austin, TXBuilt 1966 · S/N 18257855N2655RBeck Bartholomew · Dry Ridge, KYBuilt 1967 · S/N 18258355N2656CHgta Partners LLC · Grand Rapids, MIBuilt 1978 · S/N R18200196N2656GAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280569N2656KT And H Aircraft Leasing LLC · Yakutat, AKBuilt 1978 · S/N 18053029N2656QPankrate Kenneth W · Opheim, MTS/N 18257856N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356N2656SPierini William C · Chico, CABuilt 1976 · S/N 21061346N2656TCardinal Point Aviation Services LLC · Homestead, FLBuilt 1971 · S/N 28-7225079N2656ZChesebro Brian S · Oro Valley, AZBuilt 1977 · S/N 360-78N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757N2657MCurtis Christopher J · Wasilla, AKBuilt 1946 · S/N 12-970N2657WRegistered aircraftBuilt 1966 · S/N 3310N2657YNagy Leslie S · Walnut Creek, CABuilt 1962 · S/N 18051157N2658BBrowning Frank W · Port Orange, FLBuilt 1986 · S/N CE-1086N2658CMay Jeffrey P · Seligman, AZBuilt 1978 · S/N R18200198N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758N2658GSauer Roger A · Glenburn, NDBuilt 1959 · S/N 51958N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358N2658TLoer Stanley W · Grants Pass, ORBuilt 1971 · S/N 28-7205067N2658WPerez Dennys · Orlando, FLBuilt 1966 · S/N 987N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616N2659BAnderson Brian E · York, PABuilt 2002 · S/N 0237N2659GMarmon David J · Great Falls, MTBuilt 1959 · S/N 51959N2659KWickline Wayne · Flower Mound, TXBuilt 1985 · S/N 18268502N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359N2659SRovey Gerald A · Troy, IDBuilt 1973 · S/N 18502261N2659UMec Management LLC · Wilmington, DEBuilt 1986 · S/N E-2316N2659WMooney Flyer LLC · Belton, SCBuilt 1966 · S/N 1007N265AAWhitten Chris K · Alton, MOBuilt 1958 · S/N TD-132N265ACMorgan Nigel · Asheville, NCBuilt 1998 · S/N 407-98N265ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496098N265BHillestad Darrell · Aberdeen, SDS/N 25N265BSGrant Charles K · Topton, NCS/N 454N265CAZacherl Randall L · Indiana, PABuilt 2004 · S/N 965-2004N265DBKlw Coastal Equipment LLC · Destin, FLBuilt 2008 · S/N TH-2241N265DTLynn Daniel K · Beaverton, ORBuilt 1975 · S/N 18264034N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081N265FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020261N265HBBarrow Guy J · Loveland, COBuilt 1982 · S/N 265
Back to AD 2007-04-19 R1