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.

N323JLLeghorn Airfleet LLC · Columbus, INBuilt 1968 · S/N TE-608N323KJohnston Darrell · Porter, TXBuilt 1982 · S/N E-1997N323PMSrc Property LLC · Alpine, TXS/N EA-161N323PWWiseman Aviation Inc · Flagstaff, AZBuilt 1980 · S/N P-541N323RCTigers Aviation LLC · Wasilla, AKBuilt 1980 · S/N EA-87N323UShaneyfelt Samuel J · Shady Shores, TXBuilt 1966 · S/N D-8029N3240CMeves Transportation LLC · Kalispell, MTBuilt 1954 · S/N D-3905N3240NAir Services Of Mississippi Inc · Mccomb, MSBuilt 1995 · S/N E-2980N3240YMeadowlake Airpark LLC · Lenoir City, TNS/N TC2322N3241CColvin Clu D DBA · Big Cabin, OKS/N D-3906N3243BKcirro LLC · Portland, ORBuilt 1999 · S/N E-3243N3243COrthopaedic Surgery Institute Of California Mc · Newport Beach, CABuilt 1995 · S/N EA-575N3244CTowery Daniel T · Dover, DES/N D-3909N3246CKrukow David M · Hampton, IABuilt 1954 · S/N D-3911N3246RRegistered aircraftBuilt 1995 · S/N E-2946N3247CIngold Terry · Albemarle, NCBuilt 1954 · S/N D-3912N3247PCary Leasing & Management LLC · Boerne, TXBuilt 1999 · S/N EA-647N3247XExcalibur Aviation LLC · Spencer, IABuilt 2000 · S/N E-3347N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948N3249CEscobar Alfredo · Canyon Country, CAS/N D-3914N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949N3249JSelge Leasing Inc · Niles, MIS/N E-3349N324DBush David M · Englewood, COBuilt 1965 · S/N D-8016N324ESednal Enterprises · Los Gatos, CABuilt 1954 · S/N D-3908N324GT324 Aviation LLC · Cavour, SDBuilt 1979 · S/N EA-38N324ZHannon Jim H · Cumming, GABuilt 1960 · S/N D-6478N3250CHawn Terry J · Vine Grove, KYBuilt 1954 · S/N D-3915N3251CByler Allen R · Long Prairie, MNBuilt 1954 · S/N D-3916N3251WCorporate Flight Mangement LLC · Dallas, TXBuilt 1995 · S/N EA-576N3252CSw Plains Aviation LLC · Ford, KSBuilt 1954 · S/N D-3917N3252JBas Part Sales LLC · Greeley, COS/N E-3252N3252REllis Eric Lee Trustee · Lincoln, CABuilt 1995 · S/N E-2952N3254GEdling Tyrell R · The Dalles, ORBuilt 1995 · S/N E-2954N3255CWills John L · Jasper, ALBuilt 1954 · S/N D-3920N3258CJohnson Clayton D · Sherwood, ORBuilt 1954 · S/N D-3923N3259CSanders John B · Knoxville, TNBuilt 1954 · S/N D-3925N325MGLock N Climb LLC · Independence, KSBuilt 1977 · S/N D-9990N325SRFingerhut Steven · Cross Plains, TXBuilt 1966 · S/N TE-65N3262CSievers Gilbert H · Medina, OHBuilt 1954 · S/N D-3928N3262XDns Aviation LLC · Fulton, CABuilt 1995 · S/N E-2962N32631Grewell Dean R · Waukee, IABuilt 1979 · S/N D-10301N3264CDevore John A C · Marion, OHS/N D-3930N3265CMahon Paul · Reston, VABuilt 1954 · S/N D-3931N3266CRegistered aircraftBuilt 1954 · S/N D-3932N3267CHoffman Paul Kevin · Chatsworth, GAFirst renewal noticeBuilt 1954 · S/N D-3933N3269CMiedema James D · Sandwich, ILS/N D-4184N3269HEom LLC · Little Rock, ARBuilt 1996 · S/N E-2999N326FWWilliam Keith Stockman · Port Orange, FLBuilt 1957 · S/N BG-326N326KB4 Wingmen LLC · Sandy, UTBuilt 1973 · S/N CE-422N326SCuruchet Shay · Kaycee, WYBuilt 1969 · S/N D-9067
Back to AD 99-05-13 R1 WD