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.

N5609DReed Steven W · San Marcos, TXBuilt 1957 · S/N BA-315N5609SSimply Living LLC · Fort Myers, FLBuilt 1990 · S/N CE-1454N560BBSednal Enterprises · Los Gatos, CABuilt 1994 · S/N EA-562N560XWullschleger Kevin D · Avon, INBuilt 1965 · S/N TC-968N561Jacobsen John O · Prescott, AZS/N TE-918N5610Mittelstadt Charles D · Roswell, GABuilt 1955 · S/N D-4385N5610KAdams Timothy C · Ozark, ALBuilt 1964 · S/N D-7378N5610SJager Rylan W · Indn Hbr Bch, FLBuilt 1966 · S/N D-8177N5611SHenry Daniel · Paris, TXBuilt 1966 · S/N D-8150N5612KUptime Electonics Inc · Whittier, CABuilt 1964 · S/N TC-604N5614KSherwood George R · Burlington, KYBuilt 1964 · S/N D-7375N5614RLedvina Jay K · Mechanicsburg, PABuilt 1989 · S/N CE-1414N5615KDennmark Air LLC · Dighton, KSBuilt 1964 · S/N D-7377N5616SVanel Clyde · Cambria Heights, NYS/N D-8158N5617CRoot Griffin W · Fayetteville, GABuilt 1990 · S/N CE-1428N5618KLundin Michael D · Magnolia, DEBuilt 1964 · S/N D-7379N5618SAnnable John W · Pls Vrds Pnsl, CAS/N TE-139N5619KGood Natured Creations LLC · Tucson, AZS/N D-7380N561TSierra Alpha Air LLC · Piqua, OHBuilt 1961 · S/N D-6731N5621ZJon Air LLC · Dover, DES/N CE-1463N5624KWilson Robert J Jr · Gaithersburg, MDBuilt 1964 · S/N D-7382N5624SKin-Air Inc · Hendersonville, TNFirst renewal noticeBuilt 1966 · S/N D-8168N5625KChung Thomas · Stanwood, WABuilt 1964 · S/N D-7385N5627KTaxman Aviation Training Inc · Port Orange, FLBuilt 1964 · S/N TC-614N5628LRegistered aircraftBuilt 1990 · S/N CE-1460N5628SSchrier Timothy · Savage, MNBuilt 1966 · S/N TD-657N562DTriton Air Solutions LLC · Fenton, MIS/N E-3577N562ELMirman Charles B · Pinehurst, NCBuilt 1970 · S/N D-9174N562LRegistration Pending · Dover, DERegistration pendingS/N BG-115N562USua LLC · Artesia, NMBuilt 1968 · S/N TE-562N562YDion William · Coupeville, WABuilt 1991 · S/N E-2633N5632SRutherford Keith D · Bossier City, LABuilt 1966 · S/N TE-161N5633SQualitair LLC · MichelstadtBuilt 1966 · S/N D-8330N5635GFlyair Flight Academy LLC · Flint, TXBuilt 1956 · S/N D-4666N5635SRhodes Stephen · Hayti, MOBuilt 1966 · S/N D-8174N5637SSzarek Carson · San Diego, CABuilt 1966 · S/N D-8160N5639ZHowman Aero LLC · Cleveland, OHBuilt 1990 · S/N E-2535N563DBPavel John F Jr · Seattle, WABuilt 1967 · S/N D-8510N563DPSmith James E Trustee · Kalispell, MTBuilt 1962 · S/N 53-4114AN563TDGlenn Jeff P · Billings, MTBuilt 1963 · S/N TD-563N5640KHowe Eric · Fishers, INBuilt 1964 · S/N D-7397N5641STitan Realty Inc · San Diego, CABuilt 1966 · S/N D-8182N56425Peterson Todd · Cameron Park, CABuilt 1990 · S/N CE-1469N5642DMaag Dallas · Nampa, IDBuilt 1957 · S/N D-5222N5642WDemski Stanley L III Trustee · Woodbridge, CABuilt 1989 · S/N CE-1419N5644DPlane Crazy Aviation LLC · Hickory, NCBuilt 1958 · S/N BA-360N5645SVictorynow LLC · Lubbock, TXS/N TE-149N5646KSst Solutions LLC · New River, AZBuilt 1964 · S/N D-7309N5648KDale James B · Skaneateles, NYBuilt 1964 · S/N D-7585N5649KRyan Good Aviation LLC · Sioux Falls, SDS/N D-7401
Back to AD 99-05-13 R1 WD