OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N444WELiberty Steaks LLC · Latham, NYBuilt 2004 · S/N E-3579N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012N444XSmart Visual Systems LLC · Georgetown, TXBuilt 1958 · S/N D-5716N4451DRobbins William T · Lake Havasu City, AZS/N D-4594N4451SCaporale Ron · Dillon, MTBuilt 1975 · S/N E-683N4451WFlying On Edge LLC · Redmond, WABuilt 1974 · S/N CE-491N4452DM & G Aircraft LLC · Plano, TXBuilt 1956 · S/N D-4593N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611N4455BBriggs Robert B · Germantown, TNBuilt 1979 · S/N TC-2203N4455SFlying Adventures LLC · Uniondale, NYS/N TC-1875N44562Hansen Scott G · Batavia, ILBuilt 1944 · S/N 6923N4456D6 Delta Llp · Charlotte, NCBuilt 1956 · S/N D-4672N4456SFressh Air LLC · Vancouver, WABuilt 1975 · S/N E-688N4456WMetal Finishing Co Inc · Wichita, KSBuilt 1974 · S/N E-537N4457SRegistered aircraftBuilt 1975 · S/N D-9775N4458ARaimondi Johann I · Doral, FLBuilt 1970 · S/N D-9145N4458DCrum Ryan C · Lebanon, TNBuilt 1956 · S/N D-4621N4458SCn Aviation LLC · Mesa, AZBuilt 1976 · S/N TJ-58N4459SJameson Kelly J · Chappell Hill, TXBuilt 1975 · S/N E-692N445HPChopra Family Lp · Tulare, CABuilt 1985 · S/N EA-445N445PWelsh Steven M · Oxford, NCBuilt 2001 · S/N E-3415N44607Shepard Group LLC · Mena, ARFirst renewal noticeBuilt 1945 · S/N A-15N4460S300 Dollar Burger LLC · Elmhurst, ILBuilt 1975 · S/N E-691N4461DRittenhouse David C · Park Hill, OKS/N D-4596N4461WKimball Douglas S · Bedford, INBuilt 1974 · S/N TC-1677N4462DOptima Aviation LLC DBA · Lewisville, TXBuilt 1956 · S/N D-4673N4462SMaxxum Financial Group Inc · Destrehan, LABuilt 1975 · S/N TC-1876N44638Vintage Aircraft Inc · Stockton, CAS/N A-45N4463DJones Eugene E · Saint Johns, MIBuilt 1956 · S/N D-4645N4463SJ&J Aviation LLC · Hendersonville, TNBuilt 1975 · S/N CE-580N4464WMantei & Associates Ltd · Lexington, SCBuilt 1974 · S/N E-543N4465SFtp LLC · Newington, CTBuilt 1975 · S/N E-693N4466DPearce Aircraft Services Inc · Peyton, COBuilt 1956 · S/N D-4591N4466LSmyrna Aviation LLC · Edgewater, FLBuilt 2000 · S/N E-3366N4466SRegistration Pending · West Monroe, LARegistration pendingS/N D-9779N4466WPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 1973 · S/N TE-936N4467AWynn Andrew J · Montgomery, ALBuilt 1970 · S/N E-212N4467SK & M Leasing Inc · Camden, ARBuilt 1975 · S/N E-694N4468DPowr Investments LLC · Rockford, ILBuilt 1956 · S/N D-4582N4468SKyle Robert K · Madison, MSBuilt 1975 · S/N E-696N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604N4469RVon V LLC · San Antonio, TXS/N E-3290N4469WDietle Kurt D · Valley Springs, CABuilt 1974 · S/N CE-494N446ALValiair Lc Trustee · Casper, WYS/N CE-1137N446JRSpangler John T · Mount Pleasant, PABuilt 1974 · S/N CE-541N446PMorris Danny J · Upland, CABuilt 1993 · S/N E-2835N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474N446TThatcher James W · La Canada Flt, CABuilt 1970 · S/N D-9164N4470SFreitag Don M · Manhattan Beach, CABuilt 1975 · S/N D-9778N4471DKeys Sharlynn L · Sunset, TXBuilt 1956 · S/N D-4589
Back to AD 99-05-13 R1 WD