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.

N573JCCoffey John L · Iron River, WIS/N 18502396N573JFHuddleston Edward L · Oaktown, INBuilt 1973 · S/N 18052398N573MBWigley Barry L · Langston, ALBuilt 2024 · S/N 26009N573MWWhelan Company LLC · Hoover, ALBuilt 2005 · S/N 90815N573NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10941N573PUTrustees Of Purdue University · West Lafayette, INBuilt 2024 · S/N 4496584N573SMason Scott C · Lebanon, ORBuilt 1976 · S/N 913N573TLAsson David A · Sisters, ORS/N 573N573TMFarley Douglas C · Edmond, OKBuilt 1996 · S/N 001N574Yunt David W · Springboro, OHBuilt 1956 · S/N G-831N57401Adams Kenneth · Marana, AZBuilt 1973 · S/N 376-73N57405Shoaf Douglas G · Lake Oswego, ORS/N 371-73N57407Britt Elaine L · Locust Grove, GABuilt 1973 · S/N 259-73N57408Phillips Thomas G · Fairbanks, AKBuilt 1973 · S/N 494-73N5740BPash Olin M · Harlan, IABuilt 1956 · S/N 33740N5740JStonestreet Arlie D Trustee · Pratt, KSBuilt 1974 · S/N 18263509N5740MSiemens Jonathan · Seminole, TXBuilt 1968 · S/N 310P0040N5740QOasis Aero Inc · Willmar, MNBuilt 1965 · S/N 3072N5740UBraden Daniel · Port Charlotte, FLBuilt 1969 · S/N 28-26556N5740WAdams Clay · Anacortes, WABuilt 1963 · S/N 28-1415N57411Gregory Larry C Trustee · Farmington, MOBuilt 1973 · S/N 372-73N57412North County Flight Training Inc · Carlsbad, CABuilt 1973 · S/N 495-73N57413Miller Sybille A · Ashburn, VABuilt 1984 · S/N 24-1450N5741BCansino Ross G · George West, TXBuilt 1956 · S/N 33741N5741DJ&H Sewing & Vacuum Inc · Soldotna, AKBuilt 1956 · S/N 22-4441N5741FBrower Alan L · Califon, NJBuilt 1968 · S/N 28-25043N5741MCoolidge Robert · Rio Vista, TXBuilt 1968 · S/N 310P0041N5741VSjr Properties LLC · Reno, NVBuilt 1966 · S/N D-8106N5741WGonzalez Jose M · Arlington, TXBuilt 1963 · S/N 28-1435N57421Snider Roger A · Harlem, MTBuilt 1973 · S/N 498-73N57422Heefner Frederick C · Greencastle, PABuilt 1998 · S/N 23077N57423Pardue Roy S · Clifton, VABuilt 1973 · S/N 92-73N57424Wood Flying Inc · Panhandle, TXBuilt 1973 · S/N 499-73N57428Zygomalas Stefanos · San Francisco, CABuilt 1973 · S/N 370-73N5742DHemminger Blair · Gwinner, NDBuilt 1956 · S/N 22-4442N5742KCygnet Aerospace Corp · Los Osos, CABuilt 1964 · S/N TC-729N5742MAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1968 · S/N 310P0042N5742UAdams Sara · Leavenworth, KSBuilt 1970 · S/N 28-26562N5742VAllen Bruce C · Anna, TXBuilt 1966 · S/N D-8111N5742WJohnson Ronald H · Goodlettsville, TNBuilt 1963 · S/N 28-1428N5742ZBootz Terry A · Canyon Lake, TXBuilt 1984 · S/N 24-1451N57433Propwash LLC · Princeville, ILBuilt 1973 · S/N 88-73N57435Morkassel Gerald N · Waverly, OHBuilt 1973 · S/N 374-73N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643N57442Whiting Lawrence M · Silverton, ORBuilt 1973 · S/N 506-73N57446Williams Martin · Wasilla, AKBuilt 1973 · S/N 507-73N57447Hicks Richard Ted · Statesville, NCS/N 263-73N5744BMcgrew Robert P III · Red Bluff, CABuilt 1956 · S/N 33744N5744DDempsey Timothy P · Pacific, MOBuilt 1956 · S/N 22-4444N5744KFlores Isael DBA Flores & Flores Trucking · Bloomington, CABuilt 1964 · S/N CD-790
Back to AD 2007-04-19 R1