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.

N5352LStinson Jonathan L · Douglas, GABuilt 1968 · S/N 28-4655N5352NAhrens Douglas T · Los Altos, CABuilt 1980 · S/N 18267662N5352ULittle Dog Aviation LLC · Anchorage, AKBuilt 2003 · S/N 172S9385N5352WRegistration Pending · Newton, ALRegistration pending, pending cancellationBuilt 1962 · S/N 28-413N5353DMcmahan Charles B · Gakona, AKS/N 50242N5353EDillard Enterprises Inc · Pensacola, FLBuilt 1959 · S/N D-5856N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078N5353RSouthern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281157N5353WYeager Brian · Locust Grove, GABuilt 1962 · S/N 28-416N53540Orlando Aero Club Inc · Orlando, FLBuilt 1981 · S/N 17274776N53541Ps N53541 LLC · Green Bay, WIBuilt 1981 · S/N 17274777N5354BN5354b LLC · Manhattan, MTBuilt 1956 · S/N 33354N5354DGonzalez Alejandro B · El Paso, TXBuilt 1979 · S/N 17272540N5354EBisson Scott E · Livermore, CABuilt 1959 · S/N D-5853N5354NPinnacle Aviation Services Inc · Encinitas, CABuilt 2002 · S/N 4496160N5354SArcturus Bootes LLC · Wilmington, DEBuilt 1980 · S/N R18201552N53558University Of Illinois · Savoy, ILBuilt 2002 · S/N 2844083N5355DFischer Alfred M DBA · Genoa City, WIS/N 50253N5355FFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 2003 · S/N 17281166N5355LSeward Joe T Jr · Fairmount, INBuilt 1968 · S/N 28-4658N5355WN5355w Partners LLC · Lehi, UTBuilt 2003 · S/N 17281167N53569New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9395N5356DDethlefs Robert L · Clackamas, ORBuilt 1979 · S/N 17272541N5356ERedden Zana R · Sacramento, CABuilt 1959 · S/N D-5869N5356FFly By Knight Inc · Hammond, LANon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 28-7715107N5356LLehuta Steven C · Brunswick, OHBuilt 1968 · S/N 28-4659N5356NCacka Rudolph Jr · Wenatchee, WABuilt 1980 · S/N 18267666N5356PChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9393N5356UAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2002 · S/N 4496164N5356WMahler Alex · Fayetteville, ARBuilt 1962 · S/N 28-420N5356XSkywest Leasing Inc · St George, UTS/N 2843521N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528N53571George Michael F · Ferndale, WABuilt 1981 · S/N 17274781N53572Arb Aviation LLC · Palm Harbor, FLBuilt 2002 · S/N 3246208N53577New Horizon Aviation Inc · Warwick, RIBuilt 2003 · S/N 172S9399N5357BSewellfarm LLC · Thaxton, MSS/N 33357N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537N5357EHoffman Dennis M · Winchester, VABuilt 1978 · S/N 17271840N5357JArizona Bravo Lima LLC · Phoenix, AZBuilt 1980 · S/N 17273762N5357KAir Hammer Two LLC · Gulf Breeze, FLBuilt 1951 · S/N 2257BN5357WJones Michael A · Greer, SCBuilt 1962 · S/N 28-421N5357XFirn Line Aviation Inc · Wasilla, AKS/N 18-7391N53587Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2003 · S/N 172S9407N53588Davis Charles · Sanford, FLBuilt 1981 · S/N 17274782N5358BMidwest Air Services Inc · Ray, MIBuilt 1956 · S/N 33358N5358DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 17272543N5358LTwidwell Jon J · Olathe, KSS/N 28-4661N5358PWilliams George A · Bonifay, FLBuilt 1958 · S/N 24-306N5358TCarr Jon C · Shell Knob, MOBuilt 1982 · S/N R18201860
Back to AD 2007-04-19 R1