AD 98-01-08

Registered aircraft · 35,734

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

N100JDMark Aviation LLC · Kingsport, TNBuilt 1981 · S/N 414A0669N100JHSonic Aviation LLC · Carrollton, MSBuilt 1971 · S/N 310Q0421N100JPAviation Consulting LLC · Ada, MIS/N TH-1683N100KFAlbrecht Douglas D · Hobart, INBuilt 1966 · S/N 18257496N100KJDrewyor Kenneth · Eaton Rapids, MIBuilt 1977 · S/N D-9987N100KSIndependent Aviation Consultants LLC · Sparks, GABuilt 2001 · S/N 29-0262N100KWBaldassarre Thomas Anthony · Gillette, NJBuilt 1980 · S/N D-10336N100LLPremiere Brand Meats · Shasta Lake, CABuilt 1973 · S/N 414-0429N100MDHoppe Joel A · Mankato, MNBuilt 1978 · S/N 340A0535N100MLMl Aviation LLC · Boulder, COBuilt 1972 · S/N TH-249N100MMFarmer Aviation LLC · Milan, MIS/N 33611N100MTDevo Leasing LLC · Park City, UTBuilt 1979 · S/N 340A0957N100NKLand Air Sea Inc · Chesapeake, VABuilt 1969 · S/N TE-767N100NNDunnair LLC · Panama City, FLBuilt 1973 · S/N D-9465N100PCSmokey Bay Air Inc · Homer, AKBuilt 1978 · S/N 20700467N100PRKinder Eric Eugene Trustee · Tucson, AZBuilt 1970 · S/N D-9167N100PSG & C Property Hc LLC · San Francisco, CABuilt 1987 · S/N CE1140N100PXS & R Air LLC · Amarillo, TXBuilt 2004 · S/N 0953N100PZAeromotors LLC · St James, MOBuilt 1974 · S/N TH-554N100RBIngraham Donald S · New Bern, NCBuilt 1991 · S/N CE-1586N100RESchooler Jordan Benjamin · Hummelstown, PABuilt 1981 · S/N CE-987N100RGN100rg LLC · Itta Bena, MSBuilt 2005 · S/N E-3641N100SDDivan Jeremy E · Castle Rock, COBuilt 1960 · S/N 52853N100SFSafe Flight Instrument LLC · White Plains, NYBuilt 1979 · S/N TC-2211N100SLOlson Gordon N · Racine, WIBuilt 1971 · S/N 18260900N100SPWright Richard S · Half Moon Bay, CABuilt 1970 · S/N D-9107TN100TBAlexander Aviation LLC · Brighton, COBuilt 1963 · S/N CD-637N100TGBengtson Todd · Tyler, TXBuilt 1974 · S/N 310Q1150N100TXJones Joseph Clayton · Bossier City, LABuilt 1976 · S/N D-9854N100WMValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1268N100WSQualitair LLC Trustee · MichelstadtBuilt 1987 · S/N CE-1202N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249N100XPHeath Darrell L · Houston, TXBuilt 1991 · S/N CE-1564N100YNEnrique Angulo · San Diego, CAS/N 21061236N100YZCay Air LLC · North Palm Beach, FLBuilt 2004 · S/N 0814N100ZPZipjack Inc · Fernandina Beach, FLBuilt 1955 · S/N BG-4N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004N1011RRegistered aircraftBuilt 2000 · S/N 29-0248N1011SAfrican American Airlines Inc · Brandon, FLBuilt 1964 · S/N 310I0092N1012PFly Slc LLC · Salt Lake City, UTBuilt 2000 · S/N 29-0249N1013LSouthwest Medical Associates Inc · Rockport, TXBuilt 2004 · S/N 29-0327N1014WAnderson Timothy R · Wilmette, ILBuilt 1973 · S/N TE-906N10155Barth James T · Midlothian, TXBuilt 2000 · S/N 30-0057N1015FInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 18502684N1015QMayo William J Jr · Reed Point, MTBuilt 1962 · S/N 310H0015N1015WStanton Thomas Michael · Mcallen, TXBuilt 1973 · S/N TE-907N1016BWatts Daniel S · Seal Beach, CABuilt 2000 · S/N 29-0251N1016CMartinek Leasing LLC · Bellbrook, OHBuilt 2003 · S/N 29-0297N1016EHiggins Chris · Sammamish, WABuilt 2000 · S/N 29-0230
Back to AD 98-01-08