OpenAirDocs.org
AD 74-08-09 R2

Registered aircraft · 2,916

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:74-08-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-09-R2')
  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.

N8100LDynamic Avlease Inc · Bridgewater, VABuilt 1989 · S/N 146N8100VDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1985 · S/N 024N810FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 220N810MRUS Department Of Homeland Security · Washington, DCS/N 590N810NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 33207N810TARhoades Aviation Inc · Honolulu, HIBuilt 1975 · S/N 21116N8118KRegistered aircraftN-number assigned (import), not yet registeredS/N 33722N811FXFederal Express Corp · Memphis, TNS/N 283N811NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31079N811TJEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1986 · S/N 23538N812FXFederal Express Corporation · Memphis, TNBuilt 1994 · S/N 404N812NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33520N813NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30918N813TLGeoairgroup LLC · Wilmington, DES/N 45732N813VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2009 · S/N 35353N814NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29562N815NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33208N816FXFederal Express Corp · Memphis, TNS/N 347N816NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31081N817NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29558N818NHAersale Inc · Doral, FLBuilt 2000 · S/N 29311N818NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 30910N818VBPhoenix Air Group Inc · Cartersville, GABuilt 1980 · S/N 302N819FXFederal Express Corp · Memphis, TNBuilt 1993 · S/N 359N819NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 31083N8200HDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1997 · S/N 494N8200JUS Special Operations Command · Tampa, FLBuilt 1997 · S/N 478N8200RUS Special Operations Command · Tampa, FLBuilt 1996 · S/N 425N8201Omega Air Inc · Selma, TXS/N 48201N8205Omega Air Inc · Selma, TXS/N 48205N8209Omega Air Inc · Selma, TXS/N 48209N820FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 248N820NNAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29559N821AUBank Of Utah Trustee · Salt Lake City, UTS/N 24821N821AVAircol 22 · Wilmington, DEBuilt 2011 · S/N 4821N821FXFederal Express Corp · Memphis, TNBuilt 1991 · S/N 253N821JBJetblue Airways Corp · Long Island City, NYBuilt 2012 · S/N 5417N821NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30912N8222Omega Air Inc · Selma, TXS/N 48222N82247Omega Air Inc · Selma, TXS/N 48247N822NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31085N823NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29560N823SYSun Country Inc · Minneapolis, MNS/N 33971N823VVOmega Air Inc · San Antonio, TXS/N 47823N8249Omega Air Inc · Selma, TXS/N 48249N824NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30916N824SYSun Country Inc · Minneapolis, MNBuilt 2005 · S/N 33976N824VVOmega Air Inc · San Antonio, TXS/N 47824N825AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36699N825NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31087
Back to AD 74-08-09 R2