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.

N2623PJd Aero LLC · Chester, SDBuilt 1955 · S/N 22-2959N26240Gilmer Thomas · Deridder, LABuilt 1977 · S/N AA5A0478N26244Clear Blue Aviation LLC · Melbourne, FLBuilt 1977 · S/N AA5A0480N26247Royer Virgil P · Salem, ORBuilt 1977 · S/N AA5A0482N2624AWsiaki Kenneth J · Northridge, CABuilt 1953 · S/N 22-1091N2624GVietnam Helicopters · Concord, CABuilt 1959 · S/N 51924N2624NBoston Helicopters Inc · North Andover, MAS/N 0739N2624PRobinson Eric C · Palmer, AKS/N 22-2960N2624QKalarney Kerry T · Olathe, COBuilt 1966 · S/N 18257824N2624WWilkins James K · Owens Cross Roads, ALBuilt 1966 · S/N 966N2624XBritton Daniel W · Fairbanks, AKBuilt 1965 · S/N P206-0124N2624YWarner James R · Van Alstyne, TXBuilt 1962 · S/N 18051124N26253Tompkins Robert G · Panacea, FLBuilt 1979 · S/N AA5A-0819N26255Wren Donald F · West Chester, OHBuilt 1977 · S/N AA5A0485N2625CL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280436N2625MB-Hive Inc · Augusta, GABuilt 1973 · S/N TC-1586N2625QSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257825N2625SSierra Aviation LLC · Plaza, NDBuilt 1979 · S/N R18201350N2625WPatton William D · Sheridan, WYBuilt 1966 · S/N 967N26264Edb Air Inc · Wilsonville, ORBuilt 1998 · S/N 18280265N2626BRodgers Patti · Apple Valley, CABuilt 2004 · S/N 90429N2626FJohnson James E · Stevensville, MTS/N 18256726N2626KUpwind Floats LLC · Seattle, WABuilt 1979 · S/N 18053019N2626PLeguia Augusto A · Kathleen, GABuilt 1955 · S/N 22-2963N2626QTomasini William M · Boring, ORBuilt 1966 · S/N 18257826N2626R2626r LLC · Tucson, AZBuilt 1967 · S/N 18258326N2626SDelta Aero LLC · Sarasota, FLBuilt 2026 · S/N 1226-2026N26273Gasiorowski Mark A · Buford, GABuilt 1977 · S/N AA5A0500N26278Bal-Air LLC · Boca Raton, FLBuilt 1977 · S/N AA5A0502N2627CC And T Aviation LLC · Shreveport, LABuilt 1978 · S/N R18200180N2627FUlrich Robert W DBA · Twisp, WABuilt 1965 · S/N 18256727N2627MN2627m LLC · Rehoboth Beach, DEBuilt 1988 · S/N 755MN2627NCartwright Josh D · Salem, MOBuilt 1988 · S/N 0756N2627RTaylor John B · Norwich, OHBuilt 1967 · S/N 18258327N2627WDiamond Engineering & Service Co · Granger, INBuilt 1966 · S/N 3297N2628FPlata Darryl · Arlington, WABuilt 1965 · S/N 18256728N2628GArsenault Donald S · Round Rock, TXBuilt 1967 · S/N 53N2628PCraig Richard L · Sonoma, CAS/N 22-2965N2628QSannikova Olga · Sherman Oaks, CAS/N 18257828N2628ZSipes Gary C · Livingston, TXBuilt 1988 · S/N 0773N26292Qualitair LLC Trustee · MichelstadtBuilt 1977 · S/N AA5A0508N26294Dennen Corey M · Troup, TXS/N AA5A0509N26297Hunter Danny L · Gulfport, MSBuilt 1977 · S/N AA5A0510N26298Champaign Sharon E · New Holstein, WIBuilt 1977 · S/N AA5A0511N26299Ferraris Robert · Tinton Falls, NJBuilt 1977 · S/N AA5A0512N2629FFodness Jan N · Sioux Falls, SDBuilt 1965 · S/N 18256729N2629QStallings Floyd P · Vine Grove, KYBuilt 1967 · S/N 18257829N2629WHogan James C DBA · Cameron Park, CABuilt 1966 · S/N 970N262ACLavelle Jeffrey · Kenmore, WABuilt 1996 · S/N 766-96N262AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281187
Back to AD 2007-04-19 R1