AD 74-18-13

Registered aircraft · 1,642

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-18-13')
    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-18-13')
  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.

N7977BG&M Aircraft Inc · Wheat Ridge, COBuilt 1966 · S/N 32-785N79FYManaj Aviation LLC · Wilmington, OHBuilt 1979 · S/N 32-7940200N79NCLiam Clerkin Inc · Wilmington, DEBuilt 1979 · S/N 327940249N79PXOcerg Holdings LLC · Springdale, PAS/N 32-7940206N7FMAppalachian Racing Aviation LLC · Johnson City, TNBuilt 1971 · S/N 32-7240041N7SXBennett Mark A · Markleville, INBuilt 1966 · S/N 32-309N8018CPatterson Charles A · Springfield, OHBuilt 1975 · S/N 32-7600008N8088BRegistered aircraftBuilt 1979 · S/N 32-7940250N808DLSons Aviation Inc · Moody, ALBuilt 1967 · S/N 32-40309N8097CImmell Michael · Buffalo, OKBuilt 1975 · S/N 32-7640052N8099VGrannetino Gerald F · West Chester, PABuilt 1971 · S/N 32-7140072N80BRN80br LLC · Port Orange, FLBuilt 1967 · S/N 32-913N810MJCampbell Fred Cox · Monroe, NCBuilt 1974 · S/N 32-7440082N81223Eat Aviation LLC · Metter, GABuilt 1979 · S/N 32-7940263N8127KAntler Aviation And Wildlife Service LLC · Wasilla, AKBuilt 1979 · S/N 32-7940268N812WMApopka Aero Club LLC · Winter Garden, FLS/N 32-7740076N81305Wadsworth Robert M · Wellesley, MABuilt 1979 · S/N 32-7940270N8133SWoodard David · San Diego, CABuilt 1979 · S/N 32-7940271N8137DLee'S Mobile Service Inc · Holt, MOBuilt 1979 · S/N 32-7940273N8137HLimitless Horizons Sevierville LLC · Seveirville, TNS/N 32-7940274N8144ABrickbat Aviation LLC · Little Rock, ARBuilt 1979 · S/N 32-7940276N8144YAnderson John R · Belgrade, MNBuilt 1979 · S/N 32-7940277N8147JSt Rogers Holdings LLC · El Paso, TXBuilt 1979 · S/N 32-7940286N8160AKasw Aviation LLC · Warsaw, INBuilt 1980 · S/N 32-7940285N8185CKirkland Kerry G · Spring, TXBuilt 1975 · S/N 32-7640053N818AHChandler Jerome P · Redondo Beach, CABuilt 1973 · S/N 32-7340126N81LMMission Flight Academy · Yucaipa, CABuilt 1969 · S/N 32-40699N8203CKoelsch Seed LLC · St John, KSS/N 3240938N825RDFrank Richard · West Dundee, ILS/N 32-7640063N828LBBeraut Olivier Trustee · Scotts Valley, CABuilt 1972 · S/N 32-7240077N8314CR M W LLC · Florence, SCBuilt 1975 · S/N 32-7600007N833GSHogan John A · Florence, SCBuilt 1971 · S/N 32-7200010N8367CBuckwalter Daniel E · Homer, AKBuilt 1976 · S/N 32-7640061N840WMKunzelmann Christopher E · Weatogue, CTBuilt 1966 · S/N 32-711N841ADCedar Real Estate Inc · Anaheim, CABuilt 1973 · S/N 32-7340079N8424CD And A Enterprises LLC · Wilmington, DEBuilt 1976 · S/N 32-7640064N8440FMarsh John E · Washington, DCS/N 32-7740023N8485FGoff Mark A · Hot Springs, ARBuilt 1976 · S/N 32-7700008N84EBHodge Joseph Randall · Brenham, TXBuilt 1978 · S/N 32-7840173N8502NDickman Edward A · Melba, IDBuilt 1971 · S/N 32-7140052N8509CMaxwell Samuel L · Wasilla, AKBuilt 1976 · S/N 32-7640066N851VLBlue Waters Air Charters LLC · San Juan, PRS/N 32-7700009N852VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1973 · S/N 32-7400003N853VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1966 · S/N 32-630N854VLBlue Waters Air Charters LLC · San Juan, PRBuilt 1974 · S/N 32-7500010N8577CWaldmiller Robert Joseph · Rosamond, CABuilt 1976 · S/N 32-7740001N8587TJet Winds LLC · Gulf Shores, ALBuilt 1972 · S/N 32-7340022N85CTAerobsession LLC · Erie, COBuilt 1966 · S/N 32-789N8600NCen-Tex Wings LLC · Cedar Park, TXBuilt 1971 · S/N 32-7100021N8601NLpm Sky Masters LLC · Green Cove Springs, FLBuilt 1971 · S/N 32-7100020
Back to AD 74-18-13