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.

N563RVDubrouillet Thomas A · Tega Cay, SCBuilt 2018 · S/N 83563N563SBWalker Linda V · Zeeland, MIBuilt 1973 · S/N 28R-7335429N563SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881400N563TWalker Aviation LLC · Andover, KSS/N 1462-2011N563TDGlenn Jeff P · Billings, MTBuilt 1963 · S/N TD-563N563UMDelp Gregory E · Woodbury, CTBuilt 1979 · S/N 7254CN563VWRichen Owyn · Seattle, WABuilt 1968 · S/N 32-1029N563WSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 995-2005N563WWJimenez Daniel L · Goodyear, AZBuilt 2013 · S/N 82390N56404Mark Lindstrom · Fort Worth, TXBuilt 1973 · S/N 287305586N56406Blankenship Tyler D · Salisbury, NCBuilt 1980 · S/N 8013CN5640BN5640b LLC · Ashburn, VABuilt 1956 · S/N 33640N5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909N5640KHowe Eric · Fishers, INBuilt 1964 · S/N D-7397N5640NK Top J Cattle Co LLC · Eldorado, TXBuilt 1980 · S/N 8010CN5640QProps To You LLC · Mount Pleasant, SCBuilt 1965 · S/N 676N5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436N56410Ehrler Andrew N · Flushing, NYS/N 28R-7335433N56413Hupert Jason M · Grand Blanc, MIBuilt 1973 · S/N 34-7350329N56414Gordon David P · Truckee, CABuilt 1973 · S/N 287305588N56418Shepler John E · Mobile, ALBuilt 1973 · S/N 28R7335434N5641BGoebel William R · Rhome, TXBuilt 1956 · S/N 33641N5641KAndrews Nathan C · Vale, ORBuilt 1980 · S/N 7338CN5641LSale Reported · Pueblo, COSale reported, canceledBuilt 1980 · S/N 7344CN5641STitan Realty Inc · San Diego, CABuilt 1966 · S/N D-8182N5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789N56424Saunders Equipment Inc · Cold Spring, NYBuilt 1981 · S/N 8017CN56425Peterson Todd · Cameron Park, CABuilt 1990 · S/N CE-1469N56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628N5642DMaag Dallas · Nampa, IDBuilt 1957 · S/N D-5222N5642JGreater Houston Soaring Association · Needville, TXBuilt 1969 · S/N 18800592N5642MShower Michael K Jr · Wasilla, AKBuilt 1980 · S/N 7349CN5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049CN5642WDemski Stanley L III Trustee · Woodbridge, CABuilt 1989 · S/N CE-1419N5643Fingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 4033N56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591N5643CAdvance LLC · Waterville, MES/N TH-1573N5643MSandvick Randy R · Killdeer, NDFirst renewal noticeBuilt 1981 · S/N A7358CN5643NVelasquez Bailee Jude · Anchorage, AKBuilt 1981 · S/N A7361CN5643PRed Cardinal Aviation LLC · Chantilly, VABuilt 1959 · S/N 24-713N5643QGray Eric W · Erie, COBuilt 1965 · S/N 3020N5643SShedd Christopher · Holly Pond, ALBuilt 1981 · S/N 7352CN5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439N5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019CN56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437N56442Registered aircraftBuilt 1982 · S/N 7391CN56445Sturdy Gary · Anacortes, WABuilt 1981 · S/N 7351CN56446Finch Ernest B · Anchorage, AKBuilt 1981 · S/N 7385CN56447Hutton Neil J · Wray, COBuilt 1981 · S/N 7383C
Back to AD 2007-04-19 R1