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.

N4922HOptic Air LLC · Maurice, IABuilt 1981 · S/N 18267853N4922JOpat Randall J · Port Saint Lucie, FLS/N 28R-30643N4922LSpanjer William H · Pine Bush, NYBuilt 1967 · S/N 28-4288N4922SNyrhinen Aki · Reno, NVBuilt 1980 · S/N R18201461N4922TShamseldin Nathan · Buckley, WABuilt 1972 · S/N 28R-7235159N4922VHhd Aviation LLC · Hamilton, OHBuilt 1973 · S/N 172RG0417N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N49236Lakeland Aero Club Inc · Lakeland, FLS/N 23192N49237Arnold J T · Sevierville, TNBuilt 1952 · S/N 23195N4923ADaniel Arthur D · Fishtail, MTBuilt 1956 · S/N 32320N4923CSmith Justin K · Wasilla, AKBuilt 1975 · S/N 18502659N4923DHarrier Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17272399N4923LDevrnja Aero LLC · Louisville, TNBuilt 1967 · S/N 28-4289N4923YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4620N4924AMachnik Todd J · Old Lyme, CTBuilt 1956 · S/N 32321N4924DRobinson Anthony D · Brookshire, TXBuilt 1958 · S/N 51024N4924ENorthstar E & C LLC · Anchorage, AKBuilt 1979 · S/N 18503909N4924JCarper Clyde S · New Port Richey, FLBuilt 1968 · S/N 28R-30645N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624N4925CRichardson Richard E II · Windham, MEBuilt 1975 · S/N 18502660N4925FA S Air LLC · Lantana, FLBuilt 1979 · S/N 17273103N4925GSchwenker David W · Queensbury, NYBuilt 1979 · S/N 17273472N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371N4925QEsty Effew LLC · Wimberley, TXBuilt 2012 · S/N 18282326N4926AEngland John James · Montrose, COBuilt 1956 · S/N 32323N4926LRedden John V · Mooresville, NCBuilt 1967 · S/N 28-4293N4926YDenton Aerial Spraying Inc · Las Animas, COBuilt 1968 · S/N 25-4724N4927AGenx Aviation LLC · Leesburg, VABuilt 1978 · S/N 310R1504N4927CRegistration Pending · Helena, MTRegistration pending, pending cancellationBuilt 1953 · S/N 18-2116N4927DGreenville Flight LLC · Greer, SCS/N 17272401N4927LProfessional Plastic Solutions LLC · Irving, TXBuilt 1967 · S/N 28-4294N4927NRmst LLC · Mason, OHBuilt 1979 · S/N 18267457N4927QWakefield Aircraft LLC · Cooperstown, NDBuilt 1976 · S/N 18802662TN4927SDaniel L Voiers · Hephzibah, GABuilt 1980 · S/N R18201466N4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627N4928EAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17271676N4928LTwo8lima Llp · Bryan, OHBuilt 1967 · S/N 28-4295N4928SJohnson Jeffrey S · El Dorado, CABuilt 1980 · S/N R18201467N4928YSpragues Aerial Spraying Inc · Courtenay, NDBuilt 1968 · S/N 25-4727N4929AApling Randall L · Wasilla, AKFirst renewal noticeBuilt 1954 · S/N 32326N4929DUnion Flyers LLC · Union, SCBuilt 1958 · S/N 51029N4929JBurnett Robert E · San Leandro, CABuilt 1968 · S/N 28R-30650N4929LMaak Air LLC · Wahoo, NEBuilt 1967 · S/N 28-4296N492ACRobinson Mark A · Carson City, NVS/N 002N492BNTurner Harvey Jr · Raleigh, NCBuilt 1967 · S/N 28-4167N492DSSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 40.504N492FLMcknight Anna Mae · Vernon, TXBuilt 1971 · S/N 28-7125306N492JBBorke Michael F · Charleston, SCBuilt 2007 · S/N 90852N492LGSunday Punchers LLC · Monrovia, INBuilt 1979 · S/N AA5A0887N492NDChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 4496241
Back to AD 2007-04-19 R1